Formatting Pivot Tables

Hi guys,

I am interested in applying certain formatting to the "TOTALS" rows. I would like all totals rows to be highlighted in yellow and the figures in bold.

The issue is, I can do that for the current selection but as soon as I select a different cost centre from the drop down list, the formatting is not applied to that particular one. However when i re-select the original cost centre to which i applied the formatting, it will show the formatting back there.

I've read a few previous posts but i'm not so sure whether excel is capable of this.

Cheers!

Originally Posted by harrywaldron

Hi - Below is one idea, but it may not be your best solution, as it involves making a copy of the Pivoted outputs for presentation purposes (as the Pivoted "dynamic view" may have some limitations). I'm more of IT professional than Excel expert, so I'll share this as one alternative that may or may not meet your needs.

I just experimented with one of my Pivoted Table outputs and below is one idea:

1. Highlight all applicable cells in the PIVOT table worksheet
2. Paste to Notepad
3. Open a new TAB or Excel document
4. Go back to Notepad -- Select all and COPY all cells
5. On you new TAB, highlight cell A1 and perform a Paste function
6. The raw data has been pasted in and the new worksheet can now be customized as desired.

Thanks for your response Harry. Its not quite what I was looking for but I figured out there was no other way than to highlight all the rows and freeze the formatting in each criteria.

Thanks for your assistance though.

Cheers!