SubTotals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear All

Is there a way to have your subtotal row show the entire row in bold (or perhaps a different font) and just not the label? We would like to have the entire row of subtotals to stand out

Thanks
Stephanie
 
You can easily do that using conditional formatting, for simplicity assume
the table is A1:B100 with headers
select B2:B101 with B2 as the active cell (assuming you want the grand total
bold as well), do format>conditional formatting,
formula is

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

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



--

Regards,

Peo Sjoblom

Stephanie Fallon said:
Dear All,

Is there a way to have your subtotal row show the entire row in bold (or
Click to expand...
perhaps a different font) and just not the label? We would like to have the
entire row of subtotals to stand out.
 
Back
Top