Pivot table formatting - colors

[Guest]

I have a pivot table that shows invoices by week by month by division. I have
three rollups on my rows for each division- I have invoice total by count,
invoice total by dollars, and % of the total invoice dollar amount.

Is there an easy way to color code my subtotals without going all the way
down the list and doing it manually? I'd like to have all of my invoice
counts blue, all of the dollar amounts green, and the % of dollar amounts
yellow.

 

[Debra Dalgleish]

To format cells, enable selection should be turned on.
To enable selection --
From the Pivot toolbar, choose PivotTable>Select
If it's not already activated, click on Enable Selection

To format a section of a pivot table, e.g. subtotals --
Move the pointer to the left of a subtotal heading in the pivot table.
When the black arrow appears, click to select the subtotal rows
Format the selected subtotals

 

[Guest]

Thank you so much Debra this was perfect!!!

To format cells, enable selection should be turned on.
To enable selection --
From the Pivot toolbar, choose PivotTable>Select
If it's not already activated, click on Enable Selection

To format a section of a pivot table, e.g. subtotals --
Move the pointer to the left of a subtotal heading in the pivot table.
When the black arrow appears, click to select the subtotal rows
Format the selected subtotals

 

[Debra Dalgleish]

You're welcome! Thanks for letting me know that it worked.