Traffic light formula problem with two conditions
I have a column of% Complete (% Complete) and a Task Completion (ENDDATE)
I would like to generate the following conditions:
1. Green if 100% of the task is complete and it has been given on the estimated date (which is equal to or less than today)
2. Yellow if it is between 51% and 99% complete as of today
3. Red if the advance is less than 50% and the date is today
Your help is greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!