Excel Conditional Formatting Icon Sets. Just like the color scales feature the icons are added dynamically based on the numeric value and will change when the values are edited. Use icon sets to highlight values in conditional formatting in excel 1.
To assign icons based on a cell s value instead of specifying a number or percent type the cell s address in the value. I have been able to. On the home tab in the styles group click conditional formatting.
To do so we select the icon set rule from the list and then click the edit rule button.
Select a cell range which you want to add the icon sets conditional formatting. To assign icons based on a cell s value instead of specifying a number or percent type the cell s address in the value. To begin we select the conditionally formatted cells the diff cells and then open the conditional formatting rules manager dialog box by selecting the following ribbon command. The dialog should look something like this.
