Amend Font Colourand Row Colour in a pivot table row

Hi I was hoping someone could help me.

I have two pivot tables on a sheet and when I amend the fill colour to blue and font colour to white of a row it is fine until I expand a field in the Pivot Tables. Once I do this the font colour changes back to black and parts of the row colour also changes. this has been driving me crazy, I have tried amending the Design of the pivot but this still does not help. i have included the VBA for the pivot below. Does anyone have any VBA code to amend the colours? I would like Row 23 from coumn A to E filled in dark blue with font Calibri 10 in white. your help will be much appreciated

Please Login or Register  to view this content.

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.