Subtotals

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris Pringle - 02 Jul 2007 22:18 GMT

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.

Reply to this Message

Peo Sjoblom - 02 Jul 2007 22:30 GMT

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

Signature

Regards,

Peo Sjoblom

> Hello,
>
[quoted text clipped - 12 lines]
>
> Chris.

Reply to this Message