Subtotals format

Q

Quimera

I have a worksheet with a column for Name and a column for Amount. The
subtotal in the inserted subtotal line does not show the subtotal amount
in bold, though the subtotalled name is in bold.

Is there some way to show the subtotalled amount in bold as well?

Thanks for your help.
 
C

clr

Only by hand,..... or by code, if that's a viable solution.

Vaya con Dios,
Chuck, CABGx3
 
R

Roger Govier

Hi

Assuming your Amount is in column B.
Select the range of your data in column B>Format>Conditional
Formatting>Formula is> =FIND("Total",A2) >Format>Bold
This will also embolden your Grand Total row.
--
Regards
Roger Govier

Quimera said:
I have a worksheet with a column for Name and a column for Amount. The
subtotal in the inserted subtotal line does not show the subtotal amount
in bold, though the subtotalled name is in bold.

Is there some way to show the subtotalled amount in bold as well?

Thanks for your help.


__________ Information from ESET Smart Security, version of virus
signature database 4821 (20100130) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4821 (20100130) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top