conditional formatting formula help please

[Steven Bruce]

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.

[#2]

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