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.

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 wrote:

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

Thanks Dave - bloody marvellous!
"Dave Peterson" wrote in message
...
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 wrote:

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