Highlighting duplicate first and last names

[bearcub]

I get lists from our offices where they have multiple records for one employee. I would like to highlight those cells where the first and last names appear more the once. In other words, highlight all the records that are duplicated using the first and last name fields (two different columns).

I normally have conditional formatting set for the member ID number but sometimes we don't get this different from the offices.

I tried using the Countifs function as follows but it is giving me incorrect results (I think I set it up incorrectly):

COUNTIFS($B:$B, $B2,$C:$C,$C2)>1

Where Column B has the last names and column C the first names. Column A is where I would have Member ID numbers but in this instance I wasn't provided with that information.

I was trying to google the formula but I didn't know exactly how to phrase it so I find the solution

Thank you for your help.

Michael

 

[bearcub]

I mean blanks, not 0;s.

 

[Peter_SSs]

Ah, I see. How does using the Len function prevent the 0's from showing., I don't understand, sorry.

I mean blanks, not 0;s.

I have edited my last post to show an example. If there is nothing in the cell, LEN() evaluates to 0 which is treated as a FALSE. If there is anything in the cell with any characters then LEN() will evaluate to a positive whole number which is treated as a TRUE.

 

[bearcub]

Thank makes sense now, thank you for the explanation and the example.

Michael

 

[Peter_SSs]

Thank makes sense now, thank you for the explanation and the example.

Michael

No problem. Cheers.