For instance, click the Font tab and choose Red from the Color control and click OK. Click the Format button and specify the appropriate format.In the formula control, enter =COUNTIF(A:A,A2)>1.Choose Formula Is from the first control's drop-down list.Choose Conditional Formatting from the Format menu.When applying this to your own worksheet, select the first data cell in the list (column). Using the example worksheet, select cell A2.Use conditional formatting to highlight duplicates in a single column as follows: At this point, you can replace the original recordset with the filtered list (the copied list) if you want to delete the duplicates.įinding duplicates in a single column or across multiple columns is a bit more difficult. Excel will copy a filtered list of unique records to the range you specified in Copy To.
