I'm trying to conditional format a column of data based on whether the value in the cell appears in another column. After a bit of googling I have this working for numbers, but it does not like text.

My actual data is text and numbers - the sheet is just to get the method correct. In the screenshots I would expect "as1234" in column E to be highlighted as "as1234" is present in column A.

Capture1.PNG
Capture2.PNG

Thanks in advance...