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

E

Ellie

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?
 
D

Debra Dalgleish

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 Format>Conditional 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
 
Top