Hello all,

Suppose I have "abc" in A1, "def" in A2, "ghijk" in A3 and "lmn" in A4. I want to test a text string in A6 to see 1) the text string has any of A1/A2 and highlight as yellow; 2) test if the text has any of A3 and A4 and highlight as green. Let's say I have a text string in A6 like this, "abcghiabcdefghijkabcdeflmnabclmnlmn". Could someone help me with a macro?

Thanks,

MC