Sub-Totals Question

[Andrew Mackenzie]

Using the sub-totals feature in Excel the category being subtotaled is
highlighted in bold but the subtotals themselves are not highlighted. Is
there a way to format these items either using excel "as is" or with some
simple code?

Thanks,

Andrew.

 

[Dave Peterson]

Use the outlining symbols to the left to show just what you want to format (hide
those details).

Now select the range to format
edit|goto|special|visible cells only
and format the way you like.

You could record a macro if you want the code.

 

[Andrew Mackenzie]

Thanks Dave - bloody marvellous!

Use the outlining symbols to the left to show just what you want to format (hide
those details).

Now select the range to format
edit|goto|special|visible cells only
and format the way you like.

You could record a macro if you want the code.