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