Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting Question | Excel Worksheet Functions | |||
Conditional Formatting Question | Excel Worksheet Functions | |||
Conditional Formatting Question | Excel Discussion (Misc queries) | |||
Another Conditional Formatting Question | Excel Worksheet Functions | |||
conditional formatting question | Excel Discussion (Misc queries) |