Subtotals

  • Thread starter Thread starter Chris Pringle
  • Start date Start date
C

Chris Pringle

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.
 
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 format>conditional 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
 
Back
Top