30 august 2010 19:17Is there a way whenever I have a task become past due to highlight in "red" on the Gantt chart?
30 august 2010 19:28ModeratorSure. The trick is to figure out what "past due" means in your organization.You'll note that the Gantt Chart bars can be controlled using local Flagfields. You just need to develop a formula that trips the flag field to"Yes" when specific criteria are hit. Some possible options may be:[Baseline Finish]<[Status Date][Finish]>[Baseline Finish]Status =2Here's a blog post describing how to modify the Gantt Chart in 2007. Itshould be the same for 2003.http://blogs.catapultsystems.com/epm/archive/2009/07/11/formatting-the-gantt-chart-in-ms-project-2007.aspx- Andrew Lavinsky
30 august 2010 21:11Moderator
Might I add one item to Andrews post -- You should probably perform a compound test:
[Baseilne Finsh]<[Finish] AND [Actual Finish]="NA" or similar.
This way, you avoid tripping the flag for historical tasks that finished later than baseline.
As Andrew stated, it has to do with how you define "past due." There is a paper on my blog (link below) about "What Percent Complete Should I Be?" that addresses some of the "define the rules" questions.
If you feel this post answered the question, please vote for it. I am also available here: http://www.msprojectblog.com