Try something like this:

For List_1
Select the Col_A list (with A1 as the active cell)
<Format<Conditional Formatting
Cell formula is: =COUNTIF($B$1:$B$100,A1)=1
Select the format...then click the [OK] buttons

For List_2
Select the Col_B list (with B1 as the active cell)
<Format<Conditional Formatting
Cell formula is: =COUNTIF($A$1:$A$100,B1)=1
Select the format...then click the [OK] buttons

Adjust range references to suit your situation.
(Notice the dollar signs in those functions and use them accordingly)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Robin" wrote:

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