Conditional Formatting is used to highlight interesting cells or ranges of cells, and visualize data by changing the appearance of cells based on specified c · Click Conditional Formatting, then select Icon Set to choose from various shapes to help label your data which was applied with the default values set in Excel Click on the rule, then select Edit Rule to change the values your rule will follow You can change how your icons are displayed based on the values set here Let's go back to our example, which calls for our icons · The Format option will take us to the customize windows where we can change the text fonts, shaped, or define or change the border or fill For highlighting blank cells, go to the Fill tab and select any desired color as per requirement
How To Change Conditional Formatting Icon Set Color In Excel
Excel conditional formatting icon sets change color