Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
I have a pivot table which changes in size depending on the selections made and the dynamic base data that is used. I want to set conditional formatting on the table, so that if a number in the table is greater than 90% the background will be green. How do I make the conditional formatting change in relation to the table? Its no good for me to set all the cells on the worksheet to have the formatting because there is other info on it the formatting doesnt apply to. thanks for any help! thanks for any help cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |