Formatting subtotaled cells

J

joe sp

I am subtotalling data via a macro, and would like the cells in the entire
subtotal row to all be bold, like the row header cell (e.g. "999 Total" and
"Grand Total"). I'm trying to make the subtotaled data stand out from the
detail data.
 
P

Peo Sjoblom

One way would be to use conditional formatting,
assume the category is column B and the numeric totals are in C
starting with the first numeric value in C2, select from C2 to the last
value in C with C2 as the active cell, do format>conditonal formatting>
formula is

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

click the format button and select bold fonts and click OK twice
 
Top