Formula to set a color of an icon depending on the % brackets
I am trying a formula with dot icons to conditionally set the color if the budget is exceeded by:
0%<10% a dot remains green
10%>15% a dot becomes yellow
15%> a dot becomes red
I have tried this formula
but my colors are wrong. Please see an example. I suspect that my formula is incorrect because the 0.19% is negligible and -- according to our original design it should still show green.
Help Article Resources
Check out the Formula Handbook template!