| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Pivot Table Rows in Excel 2007
I have pivot table where I want to highilight an entire row if the Avg Price
column(G) falls between two price points that listed in cells at the top of the pivot table. Cell O1 has the low price point and Cell P1 has the high price point. If the Avg price in any row falls between these two price points I want the background to fill the entire row to. Can only get to work on the one cell not the row. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort Rows Pivot Table-Excel 2007 | Excel Discussion (Misc queries) | |||
| Can you set conditional formatting in pivot table? | Excel Discussion (Misc queries) | |||
| How to select different rows in Pivot table excel 2007 | Excel Discussion (Misc queries) | |||
| Excel 2007 - Conditional Formatting applied to Pivot Tables | Excel Discussion (Misc queries) | |||
| Conditional Formatting in Pivot Table | Excel Worksheet Functions | |||
Threaded Mode
