Hi---I have color scale conditional formatting on my sheet, but when I collapse or expand the data in my pivot table, the formatting changes. What can I do so the conditional formatting color scales I am using, stick and don't change when I collapse/expand?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How to keep conditional formatting when expanding and collapsing pivot table
- Thread starter Alex D
- Start date
awoohaw
Well-known Member
- Joined
- Mar 23, 2022
- Messages
- 5,096
- Office Version
- 365
- Platform
- Windows
- Web
From my perspective and understanding, which by no means is 100% certain, conditional formatting is based on cell references.
Pivot tables can change the relative location of cells if the format is based on a formula, if not completely removing when the pivot is refreshed.
But, what I'm curious about, is why not just design your pivot table to provide the records that would be selected for conditional formatting?
Pivot tables can change the relative location of cells if the format is based on a formula, if not completely removing when the pivot is refreshed.
But, what I'm curious about, is why not just design your pivot table to provide the records that would be selected for conditional formatting?
Upvote
0
Similar threads
- Question
