Let’s take a look.
For example, lets apply a medium style to this pivot table.
The applied style will be highlighted.
Once an existing style is applied, duplicate that style.
you’re able to duplicate a style by right-clicking, and choosing Duplicate from the menu.
Then, give the duplicated style a descriptive name.
Lets use Blue Gray.
The new style will appear in the upper left of the PivotTable styles group.
It will not be applied to the pivot table, so its important to apply the new style next.
First, right-hit the style and choose Modify from the menu.
However, notice that only the bolded elements are in use for any given style.
If we click through the list, we see the formatting defined for each bolded table element.
Non-bolded elements have no formatting defined.
In this case, the element we want to style is Row Subheading 1.
We want to switch the shading from blue to gray, so we need to change the fill.
Notice that the small preview thumbnail is updated as we work.
After we click OK twice, the new setting takes effect.
you might use this same approach to customize any defined element in the table.
Lets edit the style again to make the second row subheading shaded orange.
Now our style correctly applies formatting for both levels.
When we apply our custom style, we see all the formatting we defined.
