Click on "Formula Is", and enter this:

=ISNUMBER(SEARCH("defined",A1))
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"LawW" wrote in message
...
conditional formatting works very well with numbers. Is there a way to
conditionally format a cell that contains words? For example if the cell
contains "confirmed" would be green and "decline" would be red - works. What
about if the cell conatins "confirmed" but also something else in that cell?
Thanks