Pivot Table

[Deanie18]

I have created a pivot table and want the various fields to display if different colour font. I coloured the varous fields in the raw data range but pivot table display black text by default. Is it possible to colour code various fields?

 

[marka87uk]

You can format the Pivot Table how you like, but when it is refreshed the formatting will be lost.

The easiest method is to record a macro of the formatting to be applied, and then run the macro when the Pivot Table is updated.

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
' Macro here
End Sub