Conditional Formatting a cell using multiple words within cell

Question

I have a cell that contains the following text, "HOLD-PO NEW". I have cells with many different iterations ("HOLD-PO OLD","HOLD-PO", "HOLD-AR", "GOOD-PO"), but contains basically the same information. How can I conditional format the cell by saying: highlight if cell contains the words "HOLD" AND "New".

I've been looking all over the place I haven't been able to figure it out.

I tried

=AND(A1="HOLD", A1="NEW") and that didn't work.

I tried with the *  :

=AND(A1="HOLD*", A1="*NEW") and that didn't work

Please help!

Answer 1

Hi,

You can try this CF formula

=ISNUMBER(SEARCH("Hold",A1)+SEARCH("New",A1))

Answer 2

Thank you very much Mike. That worked perfectly