How does special formula apply to conditional formatting?

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

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 <[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

--

Dave Peterson