Open the Excel worksheet containing the data in question. Select the column or range you want to inspect for duplicates. Navigate to the Home tab, and within the Styles group, click Conditional ...