Nested IF RYG
I am having a hard time with this...
I need a nested if for the following:
If percentage complete is less than 60% with three days left until due I would like it red.
If anything is past due it is red
If the percentage complete is less than 75% with two days left until due I would like it yellow.
All other green
Help Article Resources
Check out the Formula Handbook template!