Monday, 6 June 2016

Excel : How to use Icon styles with data ?

Example
20
30
50
70


  • Go to Conditional formatting > Icon sets > More rules...
  • In dialog box, set the Icon style and Value ranges for different icons.







You can add more than one rules, after adding first rule :

  • Go to Conditional formatting > Icon sets > Manage rules...
  • Add / Modify / Delete rules
Posted by at
Labels:

No comments:

Post a Comment

Note: only a member of this blog may post a comment.

Subscribe to: Post Comments (Atom)