Apply conditional formatting Icon Sets to the cells

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.

要查看或添加评论,请登录

Fenqiang Zhuang的更多文章

社区洞察

其他会员也浏览了