View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rmckay rmckay is offline
external usenet poster
 
Posts: 1
Default 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?