Since there's only two cells to check, you could use:

=OR(ISNUMBER(SEARCH($B$2,$B2321)),ISNUMBER(SEARCH( $B$3,$B2321)))



Frances wrote:

Dear All,

I can successfully use the formula below to search data but it cannot be
applied to conditional formatting.

{=IF(OR(ISNUMBER(SEARCH($B$2:$B$3,$B2321))),1,0)}

Thanks for assistance in advance.

Frances

.................................................. ...............................

Try...

=IF(OR(ISNUMBER(SEARCH($A$1:$A$2,C1))),1,"")

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article ,
"Frances" wrote:

Click to show or hide original message or reply text.

Dear All,

I found the following beautiful formula from one question raised by Mr
Brantty on 01/08/2005 and the answer is prepared by Mr Biff.

=IF(OR(ISNUMBER(SEARCH({"USDA","GRADE"},C1))),1,"" )

I would like to apply the search by data field instead of specified data
like "USDA". My search data involve more than 2 criteria and they change
every time that it would be very troublesome to modify the formula every time.

I tried =IF(OR(ISNUMBER(SEARCH({$A$1,$A$2},C1))),1,"") , but it does not work.

In my case I prefer not to use vlookup or VBA or macro in order to ease the
users.

Thanks

Frances

--

Dave Peterson