SubTotals

[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

 

[Peo Sjoblom]

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

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.