Help fixing my AND/OR formatting rule

[Milos]

Hi,

I am just after a little help in fixing a formatting rule that I have written as a conditional format that I have written for QA work. Here is the code I have written:

=OR(AND(SEARCH("missing",K1),M1="No"),AND(SEARCH("lost",K1),M1="No"))

Basically I want the format to highlight when a certain cell down column M says 'No' and has corresponding cell in column K has text suggesting the reason either 'missing' or 'lost'. Currently the code allows me to enter the code, however the format fails when I generate the conditions of the rule.

Can anybody please help me fix this rule or advice me on a better way to apply a rule like this?

Thanks,
Milos

 

[Aladin Akyurek]

Try...

=AND(M1="no",OR(ISNUMBER(SEARCH("lost",K1)),ISNUMBER(SEARCH("missing",K1))))

 

[Milos]

Thanks Aladin! I could not think of a work around, this works perfectly.

 

[Aladin Akyurek]

Thanks Aladin! I could not think of a work around, this works perfectly.

You are welcome.