View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RAYCV RAYCV is offline
external usenet poster
 
Posts: 9
Default Can I use an OR function with SEARCH in conditional formatting?

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