On Nov 28, 10:34 am, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com wrote:
For things like that I have had success using conditional formats. You need
to formta the entire column but it works OK. In the conditional format use
formula is and a function something like

=right($A1, 6) = " Total"

This will identify rows that have totals on them and apply your conditional
format (bold, coloured, ...)
--
HTH...

Jim Thomlinson



"Gaffnr" wrote:
Is it possible to automatically embolden totals in a pivot table (the entire
row where a total or subtotal is)
ive looked every where and can only find template formats but nonr for a
plain pivot table with bold total rows.

I can of course do it manually but cant record macro this as the rows that
contain pivot table totals could change month to month, day to day.
--
Rob Gaffney- Hide quoted text -

- Show quoted text -

Place cursor in subtotal, then from wizard go to "select" and "enable
selection". With this button turned on, when clicking the subtotal
within the pivot table, it will automatically highlight all like
subtotals which at that point you can edit however you wish (colors,
bolding, italic, etc)