Conditional format - change cell colour according to the text within it

[Ian R]

I have a simple bank statement worksheet with colums for date, description,
in, out, balance.

I want to highlight direct debits/ standing orders/ cheque payments etc in
their own unique colour e.g all dd's are blue, standing orders orange,
cheques in green etc

Ive tried using conditional formatting but the bit I'm stuck on is that the
text varies after the initial decription e.g.

Direct Debit No: xxxxxxx
Cheque No: xxxxxx
Visa Payment to xxxxxx

Is there a way I can use conditional formatting for this purpose and get
around this problem?

Thanks for any info.

Ian

 

[DDM]

Ian, set up your conditions using the FIND worksheet function. So:

Condition 1
Formula is
=FIND("Direct Debit",A1)

So long as "Direct Debit" is part of the cell entry, it will trigger the
conditional format.

 

[Ian R]

DDM

Fantastic.

So Simple

Thanks so much!!

Ian I^)