Subtotal- plz help me

K

kumawat_s

I generally used subtotal command from Data menu.

I want that subtotal values should be in BOLD. how I can Do.

I have more than 1000 subtotal values

Thanks in advance

s. kara
 
G

Guest

Hi

One way is to group the levels so you can see only what you want to be bold.
Hit F5 and then select Special and then 'Visible cells only'. Then hit the
Bold button.
 
F

Frank Kabel

Hi
if for example column B conatins the subtotal values try
the following:
- select B1:B100
- goto 'Format - Conditional Format'
- Enter the following formula
=ISNUMBER(SEARCH("total",$A1))
- choose a bold format
 
Top