Pivot table formatting - colors
 

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.

Pivot table formatting - colors
 

To format cells, enable selection should be turned on.
To enable selection --
From the Pivot toolbar, choose PivotTableSelect
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

Ted Metro wrote:
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
Contextures
http://www.contextures.com/tiptech.html

Pivot table formatting - colors
 

Thank you so much Debra this was perfect!!!

"Debra Dalgleish" wrote:

To format cells, enable selection should be turned on.
To enable selection --
From the Pivot toolbar, choose PivotTableSelect
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

Ted Metro wrote:
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
Contextures
http://www.contextures.com/tiptech.html

Pivot table formatting - colors
 

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

Ted Metro wrote:
Thank you so much Debra this was perfect!!!

"Debra Dalgleish" wrote:


To format cells, enable selection should be turned on.
To enable selection --
From the Pivot toolbar, choose PivotTableSelect
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

Ted Metro wrote:

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
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html