G
Guest
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.
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.