It can even be useful for surpassing language barriers. These are great because they represent data in a very visual way that anyone can quickly understand. There are shapes like arrows, flags, traffic lights, stars–you name it. Under the dropdown menu labeled Icons, you can see the various icon sets you can apply to your formatting.So, in order to apply icons, go to the Style dropdown menu and select Icon Sets. This next box is where you’ll set the terms of your formatting.Click on the + icon in the lower left-hand corner, which will allow you to add a new formatting rule to the spreadsheet. The conditional formatting dialogue box will open up.Click on Format > Conditional Formatting. To apply conditional formatting, first select all of the data that you want to apply your formatting rule to.By using them in your spreadsheets, you can instantly highlight patterns and trends in your data. These icons correspond to your conditional formatting and they come in a variety of colors and shapes (stars, flags, traffic lights, etc). You might already know how to use conditional formatting in Excel, but you can use icon sets to make it even more visually powerful.

Excel icon 2021