Please help with formatting pivot table

[kenny9002]

I have an array of sales data with 8 columns. I have learnt to construct a Pivot Table from the data so I’ll be able to undertake some analyses with respect to information such as: invoices that are Unpaid (analysed according to months – with a total for each month); invoices that have been paid as @ any chosen date (also with totals for each month), etc.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I have uploaded an example of the Excel workbook with the first sheet showing the Pivot Table and the second sheet showing the original data. The boxnet uploaded link is as follows:
<o> </o>
http://www.box.net/shared/mp09yvjc5e6gfxop2ea7
<o> </o>
<o> </o>
Please, I need help on how to format the Pivot Table so that the information in the ROWS showing the Monthly Totals could be made BOLD. Also, in case I wish to give those monthly total rows a particular colour or change the fonts on those rows – whether it is possible and how I could achieve that. In summary, can I make the fonts in the ‘Monthly total’ rows Bold, change the fonts and/or give the rows any chosen colour – to distinguish the rows from the other rows.
<o> </o>
I appreciate the help of forum members on this.

Thanks.

Kenny

 

[Robert Mika]

Maybe I fully do not understand your question but you can all that do manually.

 

[kenny9002]

Maybe I fully do not understand your question but you can all that do manually.

I am sorry if you did not understand my question. As I indicated, I uploaded a Pivot Table that I created. It analyses sales data and arranges them according to months and years, and then totals sales for each month. The Rows that contain those totals for each month appear just like the information above the monthly total rows.

What I want to do is to be able to format those rows containing the totals for each month so that the information which appears as follows: eg.

Total Apr-10 400.000 120.00 280.00

can be made bold just as I have done - for all the rows with totals for each month - without having to go row-by-row to bolden the information in each row. If there are many rows, it certainly will be daunting to do so. I was wondering if there was a way to achieve this and/or even change the fonts for such rows, in a way that distinguish the monthly total rows from the other date in the pivot table analysis.

Thanks.

Kenny