A few keystrokes shorter:

=COUNTIF($F4,"*rejected*")+COUNTIF($F4,"*cancelled *")

=COUNT(SEARCH("rejected",$F4),SEARCH("cancelled",$ F4))

--
Biff
Microsoft Excel MVP


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
If you want OR, try
=OR(ISNUMBER(SEARCH("rejected",$F4)),ISNUMBER(SEAR CH("cancelled",$F4)))
You said "as well", so if you want AND, change OR to AND in the above
formula.
--
David Biddulph

"RAYCV" wrote in message
...
I am creating a conditional format using the thfe following formula

=SEARCH("rejected",$F4)

I also need the cell to be highlighted if F4 contains the word cancelled
as
well.

Brain not in gear can't work it out.

Thanks in advance