conditional formatting question

[pierre]

hello
question about confitional formating....
if i would like to say : search for the world "axe".. i could write...
=search("axe",a1)

what if i would like to say ... search for the world "axe" OR the world "bee"

THANKS FOR YOUR HELP

 

[Bob Umlas, Excel MVP]

In Conditional Formatting formula? Something like:
=IF(OR(NOT(ISERROR(SEARCH("axe",A1))),NOT(ISERROR(SEARCH("bee",A1)))))

 

[muddan madhu]

condition 1 : formula is : =OR(A1="axe",A1="bee")

choose the color | ok

 

[Sheeloo]

To get TRUE or FALSE use
=IF(ISNUMBER(SEARCH("axe",A1)),TRUE,IF(ISNUMBER(SEARCH("bee",A1)),TRUE))

 

[muddan madhu]

oops !!! check this

condition 1 : formula is :
=IF(ISERROR(FIND("axe",A1)),FIND("bee",A1),FIND("axe",A1))