For example, you may use conditional formatting to highlight duplicate cell values. Similarly, you may use conditional formatting to assign colors to items in a drop-down list.

Turn raw data into actionable insights with Excel 365’s conditional formatting. Learn to create dynamic visuals with ease in this guide.