Forum Discussion

Steven Bruce's avatar
Steven Bruce
Copper Contributor
May 24, 2018

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.
  • 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

Resources