Worksheet
(1)
FIND
(1)
Database
(1)
Dios
(1)
Vaya
(1)

Subtotals format

Asked By Quimera
30-Jan-10 06:48 PM
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.

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

clr replied to Quimera
30-Jan-10 11:29 PM
Only by hand,..... or by code, if that is a viable solution.

Vaya con Dios,
Chuck, CABGx3

HiAssuming your Amount is in column B.

Roger Govier replied to Quimera
31-Jan-10 06:09 AM
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


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

The message was checked by ESET Smart Security.

http://www.eset.com
Post Question To EggHeadCafe