Formating Subtotals

[AlanArons]

Hi all,

When the subtotal function is used, it inserts one line and bolds just the column information that the subtotal is done on.

Is there a way to either a) insert more rows, b) add a line above the subtotal line, c) Change the font attribute to bold or d) in any other way distinguish the data in the row?

Thanks for your help,

Alan Arons

 

[xlhelp]

You can use outlining symbols on the left to show just the subtotal rows.

Select those rows

The go to Edit, GoTo, Special, Visible Cells only and format.

Or

If, for example, the subtotal title is in Col A,

then,

Select the whole worksheet and go to Format, Conditional Formatting, and change "Cell Value is" to "Formula is" and
type in =RIGHT($A1,5)="Total" then select your formatting in the dialog box.


Member- AAAA Association Against Acronym Abusers

 

[xlhelp]

BTW, for anything else, you would need a macro and for that you would be better off posting in Forum 707.

Member- AAAA Association Against Acronym Abusers

 

[AlanArons]

Forum 707??

Which one is that because ultimately, I will run this from a macro

Thanks

Alan Arons{ponder]

 

[xlhelp]

Darn.... I was too lazy to put a link in. Forum 707

Member- AAAA Association Against Acronym Abusers

 

[AlanArons]

That helps. I will try there

Alan