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 MI     www.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).

Any idea of how to do this?

Thanks!
-Ben
-------------------------------------------------------------------------------------------------------------------
following is a solution to a bit more generalized problem