Are sub-totals able to be set to be bold automatically?
 

I have a large amount of sub-totals, which at the moment are not bold unless
I do a manual job of making them so. Is there any way of automating this
process in the sub-total procedure?

You can use conditional formatting to bold the rows. There are
instructions in Excel's Help files, and on the following page:

http://www.contextures.com/xlCondFormat01.html

Select the columns that contain the table
Choose FormatConditional Formatting
From the first dropdown, choose Formula Is
In the textbox, enter a formula that refers to a column in which the
"Total" text appears in the active row, e.g.:

=RIGHT($C1,5)="Total"
Click the Format button, and on the Font tab, select Bold
Click OK, click OK

Ellie wrote:
I have a large amount of sub-totals, which at the moment are not bold unless
I do a manual job of making them so. Is there any way of automating this
process in the sub-total procedure?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html