Hi

I'm using Excel XP.

I want to colour all the cells on a worksheet in green if the cells contain
the word spare - the cells may also have other text as well as the word spare
for eg. spare 09:00 or spare 15:30. I can't seem to work out how to do this
using conditional formatting - is there a way to write a custom format to do
this?

Any help really appreciated.

Anita