Directional Icon Sets In Excel. Select the icon set only checkbox. We will apply the directional icon set.
Then click ok button and the relative icon set has. This will bring up the apply formatting rule to dialogue box. If we switch to a four icon set we see that icons are assigned at 25 percent increments and if we switch to a five icon set the assignment is in 20 percent increments.
Click the reverse icon order button to change the order of icons.
Keep selecting the formula cells and then go to the new formatting type dialog box do the following operations. Set type to number for both icons. While you using the conditional formatting icon set in excel there is three colors icon. For the exclamation mark icon set 1.
