How do I display trending data in different colors (up=red)
I want to input weekly data into a spread sheet. I'd like to use the fill
color to show if the value is higher or lower than the previous week.
Ideally, I'd like this to be like a heat graph where up 4 is yellow, up 8 is
orange and up 16 is red, etc. This way visually glancing at the data will
show trends. Anyone tried this?
|