How does special formula apply to conditional formatting?

[Frances]

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!

Click to show or hide original message or reply text.

 

[Dave Peterson]

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

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