Conditional Formatting - Apply to Charts?

[DOUG ECKERT]

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.

 

[Jon Peltier]

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/ConditionalChart1.html

- Jon