Value in adjacent cell determines color

[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?

 

[Debra Dalgleish]

Jon Peltier has instructions for conditional charts that you could adapt
to your data:

http://peltiertech.com/Excel/Charts/ConditionalChart1.html