Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

anthony rag status

Forum home » Delegate support and help forum » Microsoft Project Training and help » Anthony - RAG Status

Anthony - RAG Status

ResolvedVersion 2010

Nicola has attended:
Project Introduction course
Project Intermediate course

Anthony - RAG Status

Hi Anthony please could I have some more help on assigning a graphical RAG status to a task. Plus more info on how to edit bars. Plus more info around conditional formatting. Many thanks

RE: 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

RE: Anthony - RAG Status

Hi Anthony I'm struggling with doing this I need to have the RAG status for % Complete - I have created Customized Fields and the Graphical Indicators but am stuck then on applying this to a column - your help would be greatly appreciated.

Thanks,
Nicola

Thu 26 Jul 2012: Automatically marked as resolved.

MS Project tip:

Compare Work and Duration

Duration is the timescale within which a task is done; Work is the specific time element used. For example, 3 days work in a duration of 2 weeks. To compare, add the Work field into the Entry table by right clicking a column heading to Add Field.

View all MS Project hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.