Value in adjacent cell determines color

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to have the color of individual bars on a bar chart change to reflect the data trend. If a number is down from the prior month, the bar should be yellow. If the number is down 2 months in a row, the bar should be red.

In the example:
Jan 400
Feb 450
Mar 325
April 300

I'd like the March to be yellow, because it is lower than Feb, and April should be red because it is lower than both Feb and Mar. Any ideas?
 
Back
Top