Quote Originally Posted by Fluff13 View Post
How about 
            "=AND(" & rng31.Address & "<>""Apples""," & rng31.Address & "<>""Oranges"",isnumber(MATCH(" & rng32.Address & ",Sheet5!$A$5:$A$20,0)))"
Hello Fluff13
Thank you for answer.
I changed to your solution and that gave me a Run-time error 5: "Invalid procedure call or argument"
I then changed all commas to semi-colons which resulted in all cells in rng30 became formatted according to code.
FYI, each cell in rng30 are formatted as "General" and contains first name, space and surname. Column "A" in "Sheet5" also formatted as "General".
I tried with istext but then nothing happens. Also noticed that "isnumber" doesn't change to "IsNumber".
Any idea of what's wrong?

Thanks in advance