Excel Conditional Formatting Icon Sets. The dialog should look something like this. 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 hide the cells values select the show icon only check box. 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.
Home conditional formatting manage rules.
On the home tab in the styles group click conditional formatting. Hi i am trying to set up a project management list using excel and each of the projects has a annual report and fixed due date for said report. To assign icons based on a cell s value instead of specifying a number or percent type the cell s address in the value. Click conditional formatting icon sets under home tab then select the icon set you prefer.
