software

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 quot;as isquot; 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:
gt;
gt; Using the sub-totals feature in Excel the category being subtotaled is
gt; highlighted in bold but the subtotals themselves are not highlighted. Is
gt; there a way to format these items either using excel quot;as isquot; or with some
gt; simple code?
gt;
gt; Thanks,
gt;
gt; Andrew.

--

Dave Peterson

Thanks Dave - bloody marvellous!
quot;Dave Petersonquot; gt; wrote in message
...
gt; Use the outlining symbols to the left to show just what you want to format
(hide
gt; those details).
gt;
gt; Now select the range to format
gt; edit|goto|special|visible cells only
gt; and format the way you like.
gt;
gt; You could record a macro if you want the code.
gt;
gt; Andrew Mackenzie wrote:
gt; gt;
gt; gt; Using the sub-totals feature in Excel the category being subtotaled is
gt; gt; highlighted in bold but the subtotals themselves are not highlighted.
Is
gt; gt; there a way to format these items either using excel quot;as isquot; or with
some
gt; gt; simple code?
gt; gt;
gt; gt; Thanks,
gt; gt;
gt; gt; Andrew.
gt;
gt; --
gt;
gt; Dave Peterson