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.

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...onalChart1.html

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


"DOUG ECKERT" <DOUGECKERT@discussions.microsoft.com> wrote in message
news:F46F4640-FFE3-4BFE-8974-6BECD3D25D37@microsoft.com...
> 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.