Hi guys, I know this question has probably been asked 1000 times before, but not of the solutions I have seen seem to work for me.

I have a table with several columns and rows. Column E contains the reference number for each row. Essentially, E2 to E1500 has a load of reference numbers.

To the side, not part of this table, I then have a general list of reference numbers with no formatting on it at all. This list ranges from N4 to N600. What I need to do is check every reference number in my table to the list on the side, and if it matches anything in the list for it to be highlighted. So if anything from E2 to E1500 matches anything in N4 to N600, highlight it.

Is this possible with a formula or macro?


Thanks