subtotal

[Vickie LA]

I wonder some Excel experts out there will show me how to bold and add color
to the subtotal amounts. When I use the Subtotal function, the title of the
subtotal is bolded but not the subtotalled amounts. I have to use the bold
format as well as a color to distinguish the subtotal lines only from the
list.
thank you so muc for your help!

 

[JulieD]

Hi Vickie

depending on your numbers you could use conditional formatting to do this
select the column that you're totalling
choose format / conditional formatting
choose cell value is
greater than or equal to
type in a number just larger than the biggest value in the column
click FORMAT
click Bold
Click OK
OK again
now subtotal

or
select the column that you're totalling
choose format / conditional formatting
choose formula is
type
=RIGHT($F1,5)="Total"
where F is the column that you're subtotalling on
click FORMAT
click Bold
Click OK
OK again
now subtotal

hope this helps
Cheers
JulieD

 

[Frank Kabel]

Hi
try the following:
Assumption: column B contains the subtotal values:

- select B1:B100
- goto 'Format - Conditional Format'
- enter the following formula:
=ISNUMBER(SEARCH("Total",A1))
- choose a format