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    Feb 13, 2013
user Ben Carey said:(!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?

following is a solution to a bit more generalized problem