Select cells A1:A8. On Excel’s Home tab choose Conditional Formatting, Highlight Cells Rules, and then Duplicate Values. In this case, Excel displays the Duplicate Values dialog box and also provides a preview of the formatting to be applied to your...