Conditional Shading Areas
 

I have a chart with two straight lines that move daily. I would like to
setup some kind of conditional formating so that 2 of the 4 quadrants that
are created from the intersecting lines are colored different colors from the
rest of the chart.

How do I setup a conditional shading formula / template so that the areas
bounded by the intersecting lines automatically color in?

Conditional Shading Areas
 

Jon Peltier has several examples that should work via the link below:

http://peltiertech.com/Excel/Charts/BackgroundFill.html

--
John Mansfield
http://cellmatrix.net





"Tim H" wrote:

I have a chart with two straight lines that move daily. I would like to
setup some kind of conditional formating so that 2 of the 4 quadrants that
are created from the intersecting lines are colored different colors from the
rest of the chart.

How do I setup a conditional shading formula / template so that the areas
bounded by the intersecting lines automatically color in?