formatting subtotal lines

D

david4141955

Can anyone tell me if it is possible to format only the subtotal lines
in an excel spreadsheet? I have been manually selecting the rows and
changing the text to bold and the background color to grey so they will
stand out from the rest of the report. I know there must be an easier
way to do this and if anyone can help me out I would appreciate it very
much.
 
J

Jim May

Warning !!! >>> On a back up copy of your File

Go to level Two (2) of your sub-totals which generally shows only
your Sub-totals; While there at the menu, select Edit, GoTo, Special Button..
click on Visible Cells Only (far right near bottom of dialog box);
Apply your formatting;

Go back to Level 1;
Maybe that'll work
 
Top