Hi,

I would be very grateful for any assistance to create a formula for a RAG column in project. I have created graphical indicators but require a formula to update automatically.

I require a RAG column to provide the following parameters;



1) if milestone/task is complete 100% = Complete
2) if baseline finish date is greater/later than status date and not 100% complete = Green
3) if baseline finish date is earlier than status date and not 100% complete and equal to or more than 6 days overdue = Red
4) if baseline finish date is earlier than status date and not 100% complete and 1-5 or equal to 5 days overdue = Amber

I hope this makes sense and I would be grateful for any help.

Thank you in advance.