Excel-conditional formatting question?

[SwerveNProtect]

I have a list of about 3000 names in column A and another list of names in column C. Is there a way to right a formula or conditional formatting that would highlight a name match when the match in the two columns were in the same row??? thanks!!!!!!!!!!

 

[AnotherHiggins]

* Select the two columns, making sure that A1 is the active cell (the cell in the selected columns that doesn't appear shaded)
* Go to Conditional formatting
* Change the first box to Formula Is
* Type in [COLOR=blue white]=$A1=$C1[/color]
* Click Format
* Go to the Patterns tab

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[GlennUK]

A condition of =$A1=$C1 and choose a format?

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[GlennUK]

You are too fast for me John. :-D

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[SwerveNProtect]

Ok, I tried that will no results.....both columns have the first and last name in them and I'm trying to match last names....would that make a different? The last name is listed first if that matters....thanks alot!!

 

[AnotherHiggins]

Wait, so you are not matching the two cells, but just parts of what is in the two cells?

So you want
[tab]Smith, John
to show a match with
[tab]Smith, Glenn
?

You'll get correct answers more quickly if you give us full details up front.

Change the formula to
[tab][COLOR=blue white]=LEFT($A1, FIND(",", $A1) - 1) = LEFT($C1, FIND(",", $C1) - 1)[/color]

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[SwerveNProtect]

My bad......that's correct!!!!!!! and it worked!!! you rock!!! thanks!!!!!!!!!!!!

 

[AnotherHiggins]

Glad to help.


[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[randy700]

Something like...

=LEFT($A1,FIND(",",$A1,1)-1)=LEFT($B1,FIND(",",$B1,1)-1)

Assuming both columns are LastName, FirstName

Randy