Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
crescent97526
 
Posts: n/a
Default 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

  #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






  #5   Report Post  
Posted to microsoft.public.excel.newusers
RMort
 
Posts: n/a
Default Excel subtotals, add a sort option, and BOLD the function answ

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







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"