Hi,

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

Cheers
Andy

dochoa wrote:
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, Microsoft MVP - Excel
http://www.andypope.info