Conditional Format - 2 lists of names to find matching cells.

[Guest]

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

 

[Guest]

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

 

[Peo Sjoblom]

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