Apply conditional formatting Icon Sets to the cells
EnterpriseSheet conditional formatting icon sets will help you visually represent your data with arrows, shapes, check marks, flags, rating starts and other objects.
You apply the icon sets to your data by clicking Conditional management ... > Icon Set, and the icons appear inside selected cells straight away.
In the screenshot above, you can see different values are displayed in different icons. By clicking Other rule... underneath the icon sets list to bring up the New Formatting Rule dialog. From here you are able to choose other icons and assign them to different values.
You can try online demo @ www.enterpriseSheet.com
Tips:
- To change the order of icons, click the Reverse Icon Set check box.
- To hide the cells' values, select the Show Icon Only check box.
- To assign icons based on a cell's value instead of specifying a number or percent, type the cell's address in the Value box or click the selection range icon to select a cell.