Conditional Formatting In Excel Charts

[andyGTBristol]

Hi,

I am using Excel 2010 and want to create a chart with conditionally formatting that turns the chart background green when the data is above target and red when it is below.

There are only two lines of data in the chart.

Is this possible ?

[Old_Geezer]

Yes.

[chelle7272]

Any help here?

http://peltiertech.com/conditional-formatting-of-excel-charts/

[Old_Geezer]

I don't have 2010 to check and detail but the relevant ribbon/menus will show a conditional formatting option and you can experiment from there.

[pinkyboyid]

There is also some useful instructions detailing how to use conditional formatting to change the back ground colour of a Chart:-

http://chandoo.org/wp/2015/03/27/conditionally-format-chart-backgrounds/

Basics are place chart in a fixed area of spreadsheet, e.g E3:L15, then use the Conditional Formating Options to create two new rules each which will change the Cells E3:L15 background colour based on a cell condition of the chart data cells e.g. Red if data cell A5>20, Green if A5

[Floyd_P]

yes you can tell the format how and what you want it to do. I do the same but my table is larger than just two lines and i have it turn red when it is over and certain # and green when it is below a certain #