Sub-Totals Question
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
|