Conditional Formatting formula not working

[NWPhotoExplorer]

Hello,

I am having issues with my conditional format formula. I am not sure what I did wrong, but it doesn't highlight anything. I was pretty sure I had things written out correctly, but I am not able to figure out this issue. I'm hoping someone else will see the error with the formula and can help me fix it.

=AND($H11="RF",OR(SEARCH("INFO PROVIDED",$J11),SEARCH("INFO REQUESTED",$J11),SEARCH("DESIGN",$J11)))

Basically, I want to look in the H column and if it shows RF then check the J column and see if it shows one of the above search terms. If it does, it highlights the entire row.

Thanks in advance!

 

[Marcelo Branco]

Try

=AND($H11="RF",OR(ISNUMBER(SEARCH("INFO PROVIDED",$J11)),ISNUMBER(SEARCH("INFO REQUESTED",$J11)),ISNUMBER(SEARCH("DESIGN",$J11))))

M.

 

[etaf]

EDIT , answered as typing

Search returns an Value error , if not found , that would be the issue
Just as an alternative - You could also try using a countif () with a wild card
=AND($H11="RF",OR(COUNTIF($J11,"*INFO PROVIDED*"),COUNTIF($J11,"*INFO REQUESTED*"),COUNTIF($J11,"*DESIGN*")))

 

[jtakw]

Hi,

You need to Convert the SEARCH results to TRUE/FALSE:

=AND($H11="RF",OR(ISNUMBER(SEARCH({"INFO PROVIDED","INFO REQUESTED","DESIGN"},$J11))))

 

[NWPhotoExplorer]

=AND($H11="RF",OR(ISNUMBER(SEARCH({"INFO PROVIDED","INFO REQUESTED","DESIGN"},$J11))))

When I try this, I get this error message.

 

[jtakw]

When I try this, I get this error message.

Oh, my fault, forgot this is for CF.

You should use one of the other formulas suggested in Post #2 or #3.