Conditional Formatting and Subtotals

[Mary Ann]

I have an invoice database and use subtotals from the Tools Menu to calculate
total, average and count, grouped by company. I want to use colour to make
the different types of calculation stand out. So, for example, colour the
totals one colour, the averages another colour and the counts yet another
colour. Ideally I would like to be able to colour both the text in the cells
which contain, for example “Company X Total†and the actual figure in the
corresponding cell.

Any ideas?

 

[Bob Phillips]

Assuming the text in column A, amount in B,

select A1:Bn where n is the last row
Format>Conditional Formatting
Change Condition 1 To Formula Is
Add a formula of =ISNUMBER(FIND("Total",$A1))
Click format
Select Pattern
Choose a colour
OK

 

[Mary Ann]

Fabulous, thank you

Assuming the text in column A, amount in B,

select A1:Bn where n is the last row
Format>Conditional Formatting
Change Condition 1 To Formula Is
Add a formula of =ISNUMBER(FIND("Total",$A1))
Click format
Select Pattern
Choose a colour
OK