I am using Excel 97 and want to colour a cell if it
includes the word say for example 'business' somewhere in
the text of that cell.

Checking each cell in a column of lets say a 1000 entries

Can anyone assist me with some code if this is possible
please?


Thanks

Mark