Forum Discussion
conditional formatting formula help please
Hi everyone,
I currently haveca pivot table set up with a slicer and would like to apply conditional formatting to this but whenever it's filtered the formatting stops. Is there any way to fix this?
I'm currently attempting to try and use a formula to select the range of the formatting.
I currently haveca pivot table set up with a slicer and would like to apply conditional formatting to this but whenever it's filtered the formatting stops. Is there any way to fix this?
I'm currently attempting to try and use a formula to select the range of the formatting.
With Pivot Tables the best thing to do is go to Home > Conditional Formatting > New Rule
Then you get extra options appearing at the top of the window
