conditional formatting question
 

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

conditional formatting question
 

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

"pierre" wrote:

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

conditional formatting question
 

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

choose the color | ok


On Feb 20, 11:49*pm, Bob Umlas, Excel MVP
wrote:
In Conditional Formatting formula? Something like:
=IF(OR(NOT(ISERROR(SEARCH("axe",A1))),NOT(ISERROR( SEARCH("bee",A1)))))

"pierre" wrote:
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

conditional formatting question
 

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



"pierre" wrote:

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

conditional formatting question
 

oops !!! check this

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


On Feb 20, 11:49*pm, Bob Umlas, Excel MVP
wrote:
In Conditional Formatting formula? Something like:
=IF(OR(NOT(ISERROR(SEARCH("axe",A1))),NOT(ISERROR( SEARCH("bee",A1)))))

"pierre" wrote:
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