Using data, subtotal

K

Kathie

Is there a way to format the subtotal lines that are created when using data,
subtotal and I need to add a line under the new subtotals?
 
B

Bob Phillips

You could use conditional formatting and look for total in the cell, such as
a formula like

=ISNUMBER(FIND("Total",A1))

and format with underline.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top