Conditional Formatting

[dochoa]

Is there an easy way to format the color of a bar based on it's value? Or is
it only through macros that this can be achieved?

Thanks.

 

[Andy Pope]

Hi,

Conditional charts can be created by using multiple series.
See here for more information.
http://peltiertech.com/Excel/Charts/ConditionalChart1.html

Cheers
Andy

 

[dochoa]

Thanks a lot...it works great!

Hi,

Conditional charts can be created by using multiple series.
See here for more information.
http://peltiertech.com/Excel/Charts/ConditionalChart1.html

Cheers
Andy