I have a column with percentages, for example

+------+
| -19% |
|  17% |
|   4% |
|  30% |
| -31% |

I'm trying to use the Icon Set green, yellow and red. For a negative percentage, I would like to use the Red Icon. Any percent above 90 should use the Yellow one. Below 90 percent it has to be the Green Icon.

I tried changing several conditions in the rules for the conditional formatting but I wasn't successful.

  • 1
    It depends of Excel if you have Excel-2010 and more you can do it by customizing the set but for Excel 2007 you have to use the available colors and sequences Red, Yellow, Green Customize Excel Icon Set – yass Mar 16 '17 at 19:48
  • I have excel 2013. I haven't been able to customize it to show the colors based on the way I mentioned. Do you know how to make it work? – Sam Mar 16 '17 at 19:49
  • 1
    Follow the link Customize Excel Icon Set – yass Mar 16 '17 at 19:51
  • Can you use a second column to create the icon set – yass Mar 16 '17 at 20:10
  • What formula(s) have you tried? – BruceWayne Mar 16 '17 at 20:31

Changed the second "Type" to 'Number' instead of 'Percent'

enter image description here

Modified answer from the comments. Posted as community wiki.

Your Answer

 

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.