I have a pivot table and have used the auto format (from the pivot table toolbar) report to produce colour formatted grand totals.

For each primary row added this now appears in yellow.

From the pivot toolbar i have the subtotals ticked and was wondering if/how i can set every subtotal to also appear in yellow?