Conditional Formatting - Apply to Charts?
 

Is it possible to apply conditional formatting from spreadsheet cells to a
chart? I have a set of scores formatted in RED-YELLOW-GREEN fashion, like a
stop light. I would like to show these color ranges in the chart in the grid
area.

Conditional Formatting - Apply to Charts?
 

It is not directly possible to do this. You can make a conditional chart,
which uses different series to represent the different formats. The
algorithms used to separate the data into separate series must match what
drives the conditional formatting in the worksheet.

Conditional Charts:
http://peltiertech.com/Excel/Charts/...nalChart1.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"DOUG ECKERT" wrote in message
...
Is it possible to apply conditional formatting from spreadsheet cells to a
chart? I have a set of scores formatted in RED-YELLOW-GREEN fashion, like
a
stop light. I would like to show these color ranges in the chart in the
grid
area.