Excel subtotals, add a sort option, and BOLD the function answers

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

Guest

love using the subtotal option. sometimes forget to sort the list first,
would be nice to have a sort option or reminder. Also when subtotals are
applied, the heading or titles for the subtotal is BOLD, the entire line that
was added should be bold, or have options to automatically add borders
 
if you'ld like to email microsoft with your comments the email address is
(e-mail address removed)

however, if you're asking how can the whole line go bold when using
subtotals - conditional formatting is often used to achieve this. Post
back if you'ld like more details

Cheers
JulieD
 
I'd like more details on how to acheive this with conditional formatting.
Thanks in advance.
Rmort
 
Select the cells with numbers in, let's say starting at A1, and in
Data>Conditional Formatting change Condition 1 to Formula Is, add this
formula

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

and set the Bold format via the Format button.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Back
Top