A graphic method of using icons to identify grades in Excel spreadsheets

php editor Strawberry introduces the graphic method of using icons to mark results in Excel tables. Excel tables are a commonly used office tool. By using icons to mark results, the data can be made more intuitive and easier to understand. In Excel, using icons to identify grades can be achieved by setting conditional formatting. The specific method is to select the data range to be identified, then select the appropriate icon set and rules through conditional format → data bar → icon set, and finally apply the settings. . In this way, we can easily combine data with icons to improve the effect of data visualization.

1. Open the corresponding Excel table.

2. Select the grade and click Start-Conditional Formatting-Icon Set.

3. Select the required tag according to the actual situation.

4. Select and return to the interface and you will find that it has been marked

5. If you want to see what rules it is marked by, click Conditional Formatting-Icon Set-Other Rules.

6. In the pop-up window, you can see the corresponding values.

The above is the detailed content of A graphic method of using icons to identify grades in Excel spreadsheets. For more information, please follow other related articles on the PHP Chinese website!