<div>
Both formulas work perfectly...thanks, folks! Since I'm forced to identify the 'best solution', and I'm not an expert, I made a choice based on the length of the formula, figuring a shorter formula is better, but please don't hesitate to correct me if this is an erroneous assumption.<br />
<br />
Cheers,<br />
Andrea
</div>


<div>
You're welcome Andrea! Glad we could help.
</div>


<div>
Andrea<br />
while my IF condition was unnecessary, i have put it to portray a better picture otherwise it works like this =AND(ISBLANK(AE2)=FALSE,OR<wbr />(ISNUMBER(<wbr />SEARCH(&quot;DN<wbr />D&quot;,D2)),IS<wbr />NUMBER(SEA<wbr />RCH(&quot;MDN&quot;,<wbr />D2))))<br />
<br />
but i prefer using the ISBLANK instead of nullstring &nbsp;&quot;&quot; &nbsp;becuase lets say if you have a formula &nbsp;in cell AE2 where the result is a double qoure (nullstring&quot; in that case it &lt;&gt;&quot;&quot;&nbsp; then in that case the formula would not work.<br />
<br />
so isblank is much preferable. &nbsp;<br />
<br />
i am happy with split of points between me and my friend sktneer.<br />
<br />
at the end what matter is that you get your solution, &nbsp;i do not really care much about points.
</div>


<div>
Thank you, Professor Jim Jam, for your explanation...much appreciated!
</div>


<div>
<div class="content wysiwyg-content">
I am using the following formula in conditional formatting to change the cell in column AE to yellow when the criteria is met:<br />
<br />
=AND(ISBLANK(AE2)=FALSE, ISNUMBER(SEARCH(&quot;DND&quot;,D2))<wbr />)<br />
<br />
I need to revise the formula to include an additional string of &quot;MDN&quot;, so that the criteria is now:<br />
<br />
If AE2 is not blank, and D2 has text string &quot;DND&quot; or &quot;MDN&quot;, then change cell AE2 to yellow<br />
<br />
I took a stab at trying to solve it myself with the following formula but it did not work for either &quot;DND&quot; or &quot;MDN&quot;:<br />
<br />
=AND(ISBLANK(AE2)=FALSE,IF<wbr />(OR(ISNUMB<wbr />ER(SEARCH(<wbr />&quot;DND&quot;,D2))<wbr />),ISNUMBER<wbr />(SEARCH(&quot;M<wbr />DN&quot;,D2)))<br />
<br />
Thanks!<br />
Andrea
</div>
</div>


I am using the following formula in conditional formatting to change the cell in column AE to yellow when the criteria is met:

=AND(ISBLANK(AE2)=FALSE, ISNUMBER(SEARCH("DND",D2)))

I need to revise the formula to include an additional string of "MDN", so that the criteria is now:

If AE2 is not blank, and D2 has text string "DND" or "MDN", then change cell AE2 to yellow

I took a stab at trying to solve it myself with the following formula but it did not work for either "DND" or "MDN":

=AND(ISBLANK(AE2)=FALSE,IF(OR(ISNUMBER(SEARCH("DND",D2))),ISNUMBER(SEARCH("MDN",D2)))

Thanks!
Andrea

Basing conditional formatting on more than one text string

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.