conditional formating of a chart?

[JohnA]

Can you place conditional formats on charts? I know you can with cells but I
want a chart to reflect distinction between values > or < a chosen number.

[Andy Pope]

Hi,

The is no built-in CF for charting.
Have a look at John Peltier's work around.
http://peltiertech.com/Excel/Charts/...nalChart1.html

Cheers
Andy

JohnA wrote:
> Can you place conditional formats on charts? I know you can with cells but I
> want a chart to reflect distinction between values > or < a chosen number.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info