View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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 formatconditonal formatting
formula is

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

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

--

Regards,

Peo Sjoblom

"joe sp" <joe wrote in message
...
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.