Graphical indicator formula for MS Project
Hi everyone. I am trying to create a formula to show my project's status using graphical indicators. I would like to show:
If task is 100% complete = Green
If task is not 100% and is passed the date it was due to finish = Red
If task is due in the next 14 days and is under 80% complete = amber
If task has not started = white
I have tried many examples online but can't seem to get any to work.
Any wizards out there i would really appreciate your help.
|