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 <[email protected]>,
"Frances" <[email protected]> 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
Bookmarks