conditional formatting question

P

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
 
B

Bob Umlas, Excel MVP

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

Sheeloo

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

muddan madhu

oops !!! check this

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