PivotTable.PageFieldStyle (Excel)

Returns or sets the style used in the bound page field area. The default value is a null string (no style is applied by default).

This style is used as the default style for the background area, and it's applied before any user formatting. Cells vacated when a field is pivoted from the page field area to another location retain this style.


Worksheets(1).PivotTables("Pivot1") _ 
 .PageFieldStyle = "PurpleAndGold"