Anthony - RAG Status

Hello Nicola,

Hope you enjoyed your Microsoft Project courses with Best STL.

Thank you for your question regarding RAG status, editing bars and conditional formatting in MS Project.

1) Let's start with RAG status. First of all you need to create a custom field which is done from the Project ribbon in the Properties group. Using a number field you then click the Formula button and insert a formula such as the following example:

IIf([Cost]<>0,IIf([Cost]<[Baseline Cost]*1.2,IIf([Cost]<[Baseline Cost]*1.1,10,20),30),0)

Click the Graphical Indicators button and in the tests area use Equal to 10 and choose a green icon
use Equal to 20 and choose an amber icon
use Equal to 30 and choose a red icon

Click OK

In the Gantt Chart view, change the table to cost, then insert a new column and select the custom field which you have just created using the above formula.

This will reflect items which are overbudget.

2) To edit bars, right-click the Gantt Chart area and select Bar Styles. Make wahtever changes you would like and click OK.

3) There is no conditional formatting options in MS Project.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer