Keeping Conditional Formatting in Pivot Tables

Hello Everyone,

I have a pivot table that shows an average spend and an average rating for people we hire. They both have conditional formatting on their columns to show colours based on their value (i.e. ratings above 75 show a green, below 25 show red etc.). However, when I filter them all formatting is lost. This happens whether I click the "plus" signs to filter the column labels or if I select a different report filter.

I have tried setting the conditional formatting to "All cells showing 'Spend' values" (same with ratings) and also tried applying it to the whole column but it still disappears.

I have also selected "preserve cell formatting on update" in the pivot table options.

I have looked through the threads but unfortunately couldn't find a solution that worked, as most suggested the above as solutions.

Any help would be much appreciated.

Thank you

Slightly embarrassing...

In attempting to hide my personal information so I could submit my workbook the problem seems to have rectified itself. All I did was delete the original conditional formats and reapply them. Now they seem to stick.

This only started happening when I started locking the worksheet. Could that have potentially caused this?

Anyway, sorry for wasting your time but thank you for your quick reply. I only hope they stay for the duration now.