Can I use an OR function with SEARCH in conditional formatting?

[RAYCV]

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

 

[Ashish Mathur]

Hi,

Try this formula in conditional formatting

OR(ISNUMBER(SEARCH("rejected",A10)),ISNUMBER(SEARCH("cancelled",A10)))

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[David Biddulph]

If you want OR, try
=OR(ISNUMBER(SEARCH("rejected",$F4)),ISNUMBER(SEARCH("cancelled",$F4)))
You said "as well", so if you want AND, change OR to AND in the above
formula.

 

[T. Valko]

A few keystrokes shorter:

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

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