Use conditional formatting formula is and countif

For column A

=COUNTIF($B$1:$B$50,A1)0

for B

=COUNTIF($A$1:$A$50,B1)0


--

Regards,

Peo Sjoblom
"Robin" wrote in message
...
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