Graphical indicator formula for MS Project

Quinn87 · #1 03-10-2021, 06:50 AM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MS Project - RAG status formula	imzkhan4	Project	0	11-13-2018 12:25 PM
Graphical glitching in MS Word 365	seanspotatobusiness	Drawing and Graphics	1	07-28-2018 02:55 PM
20 day gap indicator	Planner18	Project	3	03-23-2017 04:09 PM
Graphical Indicators customisation	Guloluseus	Project	5	03-03-2014 06:06 PM
Implementing excel formula in project	nawab35	Project	6	08-04-2011 05:45 AM