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

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

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

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

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

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