Conditional Formatting gives decorative look on active worksheet. This feature allows you to apply alternate color shading between rows.
Quick Analysis feature allows you to analyze your selected range of cells but also prepare chart, conditional formatting and many more.
Conditional formatting feature in Microsoft Excel allows you to easily highlight one or more cells which have specific text in active worksheet.
If you want to identify and highlight all duplicate values then read this guide which helps you to find duplicates using conditional formatting in Excel.