ms project
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Project Training and help » MS Project

MS Project

resolvedResolved · Low Priority · Version 2003

replyReply Thu 22 May 2008, 16:46Delegate Teresa said...

Teresa has attended:
Project Intro Intermediate course
Visio Introduction course

MS Project

How can I imput a RAG status on the project plan?

For upcoming training course dates see: Pricing & availability

replyReply Wed 4 Jun 2008, 16:56Trainer Andrew said...

RE: MS Project

Hi Teresa

Thanks for your question. I've assumed that you have some costs associated with your tasks and that a baseline has been saved too.

With that all set try this:

Insert a new column and select the Cost1 field. We'll use this column to display the graphical indicator.

From the Tools menu choose customize. Select the Custom fields tab and make sure Type is set to Cost. From the list of text fields available choose Cost1(it's probably already selected for you)

We need to set this field to get the current cost of the task so click on the formula button and enter the name of the field we are going to test. The field name should be in square brackets e.g. [cost] and click on OK and OK again. On your table you will see the column you created now has a the cost of each task displayed.

Go back into Tools > customize and choose cost1 again. This time click on Graphical Indicators. In the first row choose "is less than or equal to" and in the field cell enter [baseline cost]. Finally in the image cell choose a symbol to show if the test is met (eg the green ball)

Lastly on the next row down enter the test "is greater than", the field will be [baseline cost] again and the graphical indicator can be the red ball. Click OK to accept the edits and OK again.

Now if a task costs more than its baseline cost Project will show a red indicator rather than a green one.

I hope this helps - do let us know if you have any questions.

Kind regards,

Andrew
in the lower part of the dialog box choose graphical indicators

 

Please browse our web site to find out more about
microsoft projects courses and other Microsoft training courses.

Ms project tip:

Autofit column width – Project (all versions)

a. Highlight the column or columns you wish to alter the width of.
b. Double click the dividing line between the columns. This dividing line is the break between the columns on the column headers (grey buttons showing the column letter at the top of each column). When you hover your mouse over one of these dividing lines the point will change and show an arrow pulling a line in two directions. When you have this mouse pointer you should double click to get Project to automatically set the column width to fit the contents of the column (autofit)

View all MS Project hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard