Can conditional formatting be used to format chart elements?

[socpbro]

I'm using Excel 2003 and want to conditionally format bars in a bar chart to
reflect the range of values they show. Is this possible...?

 

[Andy Pope]

Hi,

By using additional series and formula yes it is possible.
http://peltiertech.com/Excel/Charts/ConditionalChart1.html

Cheers
Andy