Conditional format range changes when refreshing pivot

[HarryKlein]

Hi, I have a sheet with a pivot.
I set up some conditional formatting on it, but the range of this formatting is changing every time I refresh the pivot.
How could I prevent it?
Thank you

[romperstomper]

Did you apply the format to the pivot table specifically, or to the cells? If it was the latter, you'd have to use code to reinstate it.

[HarryKlein]

Hi Rory,
thanks for the answer. And what if the format is applied to the pivot?

[romperstomper]

If it was applied to the pivot it shouldn't be affected by a refresh.

[HarryKlein]

Thank you for your answers.