So I am trying to set up some conditional formatting using formulas the red/yellow/ green icons. The green and yellow icons seem to be capturing correctly for some reason I can't get the red icon to show up.
Conditional format.PNG
Here is the formulas I put in. I want it to be green if they exceed their goal, yellow if they reach 80% of the goal, and red for anything lower.
results.PNG
As you can see, the fourth column should be red, as they did not meet 80% of the goal, but it still shows up as yellow. I can't figure out how to include the red icon in this table. And I am already aware that there needs to be a separate rule for each line.
Any advice would be appreciated!
Bookmarks