Duplicates

Yes you can use conditional formatting to check. Go to the conditional formatting tab in the ribbon and go to HIGHLIGHT CELLS, duplicate values

That's not available in Excel 2003

@Bryan, be sure to take note the Excel Version the OP is using (under their name on the left). There is no ribbon or CF for duplicates in Excel 2003.

@Imance, if the names are in column A starting at A2, you can use another column to flag duplicates. I like to NOT flag the first occurance, but flag all the others. In an adjacent column put this in row 2:

=IF(COUNTIF($A$2:$A2, $A2)>1, "Dupe", "")

....and copy down. The word "Dupe" will appear on the 2nd+ occurrences of any value n column A.


You could do the same thing in conditional formatting in the original data.

1) Highlight the range A2:A100 (however far down the data goes)
2) Format > Conditional Formatting > Condition1:

Formula Is: =COUNTIF($A$2:$A2, $A2)>1
Format... Pattern... Red