I have a sheet with two seperate columns of names and would like any name in
list 1 that also appears in list 2 to be highlighted in both lists.

Exapmple...

A B
1 Dan Bill
2 Dave Andy
3 Pete Dave
4 Chris Darren

Result - Cells A2 and B3 would appear with red text.

Thanks in advance!

Robin