Conditional Formatting in Pivot Table Changes After Refresh

[vk7]

I applied conditional formatting to my Pivot Table to highlight rows that contain the word "Total," and it works as expected. However, every time I refresh the Pivot Table, the conditional formatting changes or gets altered automatically.

Is there a way to prevent the conditional formatting from being modified when the Pivot Table is refreshed?

Before Pivot Table Refresh:


After Pivot Table Refresh:

 

[vletm]

vk7​

Do You ask something for Your previous Pivot-table?
... Could You use one of those Designs?

 

[vk7]

Yes, it was about the previous pivot table, but since this is related to conditional formatting, I thought it would be better to create a new post to avoid any confusion. I could use the Design feature to format the table, but my goal is to highlight the row that contains the total, so I thought conditional formatting works best for this.

As you can see in the attached Excel, the conditional formatting I set has been reset, and the highlight only applies to part of the row, with a few cells missing. So, I'm here to check if I'm missing something or if there's a different way to achieve the same result without the conditional formatting being reset.

 

[vletm]

vk7​

Your conditional formatting range is ... small.
Change it eg $J$12:$Q$200
>> But same kind of 'effect' can get with those Designs <<

... or You could study how to create own style.

 

[vk7]

Yes, you are right. Design seem to do the exact same thing. Thanks again.