I’m wondering if there’s a way to format the 4th, 5th, etc… Row Subheading when modifying the pivot table styling in Excel or through VBA? I can see the Pivot Table Elements only allow styling up the the 3rd Row Subheading.

My Sheet:

I’ve even tried to format column “B” through VBA; trying to unbold. However, that didn’t work as I assume the Pivot Tables styling takes precedent?

ThisWorkbook.Worksheets("Sheet1").Range("B:B").Font.Bold = False

I’ve also looked at unselecting the “Row Headers” option (to remove bolding on Column “B”) under Design Tab > PivotTable Style Options but that removes the bolding from my “Name”, “Dep Name”, “Cat Name” rows and my Column “B” rows.