View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Bob Phillips
 
Posts: n/a
Default Excel subtotals, add a sort option, and BOLD the function answ

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