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.