How do I format to highlight same names but different identification numbers?

**officegirl14** · 01-28-2015, 02:54 PM

I would like to be able to format my spreadsheet to check for duplicate first and last names (which are in separate columns) and then highlight only if the identification number for those people is different. For example:

Column A Column B Column C
Smith John 1234
Smith John 5678

Thanks again for any help!

**AlKey** · 01-28-2015, 03:18 PM

Try this

Select cells in A:C range then on the Home tab go to Conditional Formatting, Highlight Cells rules, and Duplicate values

**officegirl14** · 01-28-2015, 03:36 PM

Thank you for responding, but if I want to highlight for different values (the identification number) among duplicate values (people with the same name), then will this work?

**FDibbins** · 01-28-2015, 04:54 PM

Without seeing samples of your data (workbook), probably "use formula" in the CF options, and then something like...
=COUNTIFS($A$1:$A$12,$A1,$B$1:$B$12,$B1,$C$1:$C$12,$C1)=1