Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I bold or have different colors in a pivot table? | Excel Discussion (Misc queries) | |||
pivot table formatting | Excel Worksheet Functions | |||
Visual Basic Help - Pivot table, formatting colors | Excel Discussion (Misc queries) | |||
Pivot Table Formatting | Excel Discussion (Misc queries) | |||
Pivot Table border formatting and pivot chart formatting | Excel Discussion (Misc queries) |