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.

Colouring late milestones red - help please!!

7 replies [Last post]
Fri, 2010-02-19 06:50
Adam Hastie
User offline. Last seen 14 years 12 weeks ago. Offline
Joined: 19 Feb 2010
Posts: 5
Groups: None
I am trying to change the colour of milestones, not started/finished on time, to red.

Basically, I want the Gantt view to what milestones should have been completed by today’s date but haven’t, and what have been completed by today’s date.

I have managed to turn completed milestones to green by creating a green milestone in Bar Styles and assigning it to be displayed From: Actual Start and To: Actual Start.

Can anyone help please?????

Thanks, Adam
Top

Replies

Fri, 2010-02-26 11:44
#1
Adam Hastie
User offline. Last seen 14 years 12 weeks ago. Offline
Joined: 19 Feb 2010
Posts: 5
Groups: None
Bo and Rafael - thank you both for your solutions.

My MS Project Plan now works as I need it to and it looks "the Cat’s pyjamas", as they say.

Thanks, Adam
Top
Fri, 2010-02-26 05:19
#2
Bo Johnsen
User offline. Last seen 8 years 11 weeks ago. Offline
Joined: 28 Feb 2006
Posts: 119
Groups: Building Information Modelling, Civil Engineering
Hi Adam,

A simple solution to your question in post #1 could be to introduce a Flag1 with e.g. the formula:
[Current Date]>[Start] And [% Complete]<100

and then a make a bar styles for Milestone;Flag1 in colour red. The milestone will then change to red if not completed by time now.

If you want to relate to the Status Date instead, then just replace that with Current Date in the formula above.

Regards,

Bo

Top
Thu, 2010-02-25 11:49
#3
Rafael Davila
User offline. Last seen 7 hours 26 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Groups: Spider Project Team
Constraints not met

After updating the job with no progress as to make all constraints not met you can get the relationship from the formula and use it to set your conditional formatting. You can also use graphical indicators, these can be more effective.

Look how constraint type changed, is the way MS Project works its updating, there is no way around that I know.

Formula for Number10 :
IIf([Text10]="Start No Earlier Than" Or [Text10]="Start No Later Than",[Date10]-[Start],IIf([Text10]="Finish No Earlier Than" Or [Text10]="Finish No Later Than",[Date10]-[Finish],0))
Top
Thu, 2010-02-25 06:05
#4
Rafael Davila
User offline. Last seen 7 hours 26 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Groups: Spider Project Team
Adam,,

Sorry with my late response but PP emails notice of postings in threads you have postings are not being received, probably due to changes in the working on PP site; this place will get even better.

I email you via PP mail.

My main scheduling software is not MS Project but as everyone at times I have to deal with this very useful software, any excuse to practice MS Project is good.

MS Project as it updates it changes original constraints field so you will first have to record original constraint type and date on custom fields as to freeze the data and be able to compare them with Start and Finish dates. This way you can get data for constraints already not met and also for those predicted not to be met. In one custom field you can set MS Project to calculate overrun duration.

I will post the file so everyone interested in helping us can use it if wish to. I am working on a job quotation so for a few days will be busy and my response will be slower than usual.

Best regards,
Rafael
Top
Fri, 2010-02-19 08:47
#5
Gary Whitehead
User offline. Last seen 4 years 49 weeks ago. Offline
Joined: 24 Mar 2009
Posts: 1215
Groups: Building Information Modelling, Content Moderators, Petro-Chem / Oil & Gas, The GrapeVine
Hi Adam,

There are spammers and other nefarious beings active on these forums, so we encourage members no to post their email adress in the open forums.

If you want to give Rafa your email, please send him a private message (click on the envelope icon next to his name) to keep it secure.

Cheers,

G
Top
Fri, 2010-02-19 08:06
#6
Adam Hastie
User offline. Last seen 14 years 12 weeks ago. Offline
Joined: 19 Feb 2010
Posts: 5
Groups: None
Rafael, Thanks for you quick response.

As I’m a beginner to MS Project I need help to do this.

Can I show you the file? [email removed by Gary W]

Thanks, Adam
Top
Fri, 2010-02-19 07:53
#7
Rafael Davila
User offline. Last seen 7 hours 26 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Groups: Spider Project Team
If you are using date constraints then you got the required fields to do so.

If not using constraints then you can set a user date field to enter your milestone target date and another field to identify if a start or finish target. Then you can set up an if-statement formula that will compute the difference between the actual start/finish and your target start/finish.

If you find this approach acceptable and need further help, let me know.

By the way I avoid using finish date constraints other than to fix a milestone that does not drive any activity. I avoid messing with backward pass computations. I believe the implementation of finish constraints that set your constrained activity Late Finish equal to the constraint date rather than the CPM logic computed value is wrong. Unfortunately even the PMI favors use of negative float and many software developers, if not all, followed this misleading implementation.

Best regards,
Rafael
Top