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

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


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

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

I'd like more details on how to acheive this with conditional formatting.
Thanks in advance.
Rmort

"JulieD" wrote:

if you'ld like to email microsoft with your comments the email address is


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

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

Select the cells with numbers in, let's say starting at A1, and in
DataConditional 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)

"RMort" wrote in message
...
I'd like more details on how to acheive this with conditional formatting.
Thanks in advance.
Rmort

"JulieD" wrote:

if you'ld like to email microsoft with your comments the email address
is


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

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

Great! that worked like charm!
Thanks for the help!

"Bob Phillips" wrote:

Select the cells with numbers in, let's say starting at A1, and in
DataConditional 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)

"RMort" wrote in message
...
I'd like more details on how to acheive this with conditional formatting.
Thanks in advance.
Rmort

"JulieD" wrote:

if you'ld like to email microsoft with your comments the email address
is


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

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