Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Microsoft Project 2010 Milestones

5 replies [Last post]
Yvonne Stokes
User offline. Last seen 12 years 38 weeks ago. Offline
Joined: 11 Nov 2011
Posts: 4
Groups: None

Does anyone know how to make milestones that are not 100% complete but have a finish date that is in the past turn to red?

Replies

Bo Johnsen
User offline. Last seen 8 years 33 weeks ago. Offline
Joined: 28 Feb 2006
Posts: 119

Yvonne,

A couple of initial remarks: 1) A milestone can only be 0% complete or 100% complete. Nothing in between. Milestone is defined as its duration and work being zero, so saying a milestone is 60% complete would just give the result 60% times zero which is still zero.

2) Secondly, you can't have uncompleted activities/milestones in the past, however, many people still prefer to see the progress (zig-zag) line, so let's forget about that for a while.

To answer your question you could make a formula for a flag field asking that if "Baseline Finish" is less than "Status Date" and "Actual Finish" equals "NA" then the flag field would turn "Yes" or something similar. Then make a red bar style incorporating that flag field. All bars for uncompleted activities that should have been completed according to the baseline will now automatically turn red.

Regards,

Bo   

Hlamalani Baloyi
User offline. Last seen 12 years 15 weeks ago. Offline
Joined: 20 Jan 2012
Posts: 18
Groups: None

You right click on that specific activity, you click on information,you go to the advanced tab,then on the bottom left you click to make that activity a milestone,

Hope you find it helful

 

Hlami

Kashif Khan
User offline. Last seen 10 years 43 weeks ago. Offline
Joined: 17 Nov 2011
Posts: 46
Groups: None

simple trick, right click on the milestone diamond and change its colour to red, though it is a manual trick but it will solve ur problem.

Yvonne Stokes
User offline. Last seen 12 years 38 weeks ago. Offline
Joined: 11 Nov 2011
Posts: 4
Groups: None

Thanks for the response but I want to be able to show the task is running late and have it highlighted in red.

Kashif Khan
User offline. Last seen 10 years 43 weeks ago. Offline
Joined: 17 Nov 2011
Posts: 46
Groups: None

Hi.

In your case your program is not updated and scheduled on milestone date, you need to update the activities on which this milestone was dependent on and after that when you will reschdule the program then the milestone will become 100%.

 

regards

kk