Conditional Formatting and Subtotals
 

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?

Assuming the text in column A, amount in B,

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

--
HTH

Bob Phillips

"Mary Ann" wrote in message
...
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?

Fabulous, thank you

"Bob Phillips" wrote:

Assuming the text in column A, amount in B,

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

--
HTH

Bob Phillips

"Mary Ann" wrote in message
...
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?