Conditional Formatting Icon Sets. From the home tab you can select conditional formatting and choose manage rules. This pulls up the conditional formatting rules manager.
Select a cell range which you want to add the icon sets conditional formatting. To hide the cells values select the show icon only check box. Let s take a look.
To change the order of icons click the reverse icon order button.
To change the order of icons click the reverse icon order button. By default for 3 icons excel calculates the 67th percent and 33th percent. Click conditional formatting icon sets under home tab then select the icon set you prefer. They only let me change the font formatting borders patterns etc.