| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell shading with conditional formatting | Excel Discussion (Misc queries) | |||
| Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
| Conditional Formatting Shading For Visible Rows Only | Excel Discussion (Misc queries) | |||
| Conditional formatting: alternate shading PLUS red for 0 values | Excel Discussion (Misc queries) | |||
| conditional formatting-shading | Excel Worksheet Functions | |||
![Tim H[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
