Pivot table row label field font

[fistikseker]

I'm trying to change the pivot table rowlables section/ column. When i right click the column >> then format cell, it only works as the valus current status, like when I collapse/ expand the data/ the fonts are not changing accordingly. There should be a way to do it in VBA i guess, but not sure what/ or how. can someone please advise

 

[Anant Chirmade]

Not exactly sure if this is the answer..
However, I think it is regarding the AUtomatic updation of pivot table formats.

To change this setting right click on pivot area >> Click on Pivot Table Options..

Then Under Layout and Format, set the "Preserve Cell formatting on Update" box ON.