Loss of Formatting on Refreshing Pivot Table

Copper Contributor

When I refresh my pivot table, I lose some of the formatting. I've tried several fixes including "Preserve cell formatting on update". It is probably something stupid I'm missing, but I've run out of things to try.
Can someone please help with this issue. I can provide file if needed.

I lose the dark blue format as it turns to light blue. I have attached a screenshot. I can provide the file if need be.

94604-607c8a92e80965c19b7fec6db53bc6d3.jpg
Thanks,
Ken Mc

3 Replies
This method is working for me. To move your mouse over column header in pivot table until it changes to black arrow, then click column header to select whole column. Once the whole column is selected, you may proceed to format cell. This method is also working perfectly even you use conditional formatting. Please take note that in some cases, you may need to select more than one column for this method to work.