With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Wednesday, February 13, 2013
yogi_Format A Column Of Positive And Negative Numbers So Even Color Blind People Can Visualize
Google Spreadsheet Post #1028
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MIwww.energyefficientbuild.com. Feb 13, 2013 user Ben Carey said:(http://productforums.google.com/forum/?zx=tcy1r1xn72ay#!category-topic/docs/spreadsheets/YvaR944I3a8)
Alternative percentage formatting
I'm trying to come up with a way to show comparisons between periods.
I have a percentage as the value and would like to show different results if it's positive or negative. I can do this by changing the color, however I'm color blind so that doesn't help tremendously.
I'd prefer to show a "↑" or a "↓" before the percentage. Alternatively, if the special characters aren't possible then I'd like to just use a "+" or "-" (the "-" is there already with the default formatting).