Conditional Formatting
 

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.

Conditional Formatting
 

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

Conditional Formatting
 

Thanks a lot...it works great!

"Andy Pope" wrote:

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