Thread: Subtotals
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Subtotals

If you mean that you want to bold the amount/count etc for each line that
says Total in the leftmost column?

Assume you have amounts starting in B2, s elect B2 down until the end and
make sure B2 is the active cell (it will be if you select from B2 down)

then do formatconditional formatting, formula is then in the box put

=ISNUMBER(FIND("Total",$A2))

next click the format button (while you are still in the conditional
formatting dialogue box) and select fonts, click on bold and click OK twice


--
Regards,

Peo Sjoblom


"Chris Pringle" wrote in message
...
Hello,

I use subtotals to help me sum the totals of the differing nominal
accounts in my management accounts. I collapse the spreadsheet so I can
see the totals of each nominal and then highlight each line so that I can
format the subtotals making them bold and increase the font size to make
them stand out once printed.

There can be many nominals and lines that differs from time to time
throughout the accounting period.

Is there a way I can do this quickley?

Regards,

Chris.