Understanding your data and how Excel's conditional formatting works is the key to accurately using icons to represent data.

Click Conditional Formatting > Manage Rules. Select the icon set you just created and click the Edit button. Here, you can set how to display the icons based on the value of the cell.

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

Excel's conditional formatting lets you formats cells based on the value of those cells or their formulas. Learn the basics of this amazing feature.