# Make milestone turn red when it's overdue

• ### Question

• Is it possible to make a milestone turn red when it's overdue (pass today's date)? Also, is it possible to roll this green and red milestones to Project summary level?
Saturday, February 11, 2012 7:50 PM

• Hi Mimi,

What is overdue?

This is a formula that works:

IIf([Milestone];IIf([% Complete]<100;IIf([Finish]>[Baseline Finish];IIf([Baseline Finish]<Now();Yes;No);No);No);No)

(With US settings you need , instead of ;)

Not done, later than the baseline, which in turn is before today.

Greetings,

Sunday, February 12, 2012 7:34 AM

### All replies

• Mimi,

There is no conditional formatting in Project.  However, you can set a deadline and this will give you an icon in the indicators column when it is past due, or when it is past its planned date.  I use what is called a deadline table, originally created by Sam Huffman, MVP.  You can find information on it at the following MPUG link:

Rolling inidications up to the Project Summary task cannot be done the way you are asking.

Regards,

Gregg D. Richie, PMP, MCTS; Author, Microsoft Project 2010, Microsoft Official Academic Course Series

Saturday, February 11, 2012 8:30 PM
• You can turn the Black Diamond Red by having a formula that evaluates as true if the task is overdue. Add a new bar in Bar Styles for task type Milestone, Flag1 and format it red.

Rod Gill

The one and only Project VBA Book Rod Gill Project Management

Saturday, February 11, 2012 8:34 PM
• Hi,

To complete Rod's answer: you can also roll this up by creating a style Milestone, Rolled up, Flag1 and roll up as usual.

Greetings,

Saturday, February 11, 2012 9:58 PM
• Can you give me a formula if milestone is past due, it will change flag1 to yes?
Sunday, February 12, 2012 3:43 AM
• Hi Mimi,

What is overdue?

This is a formula that works:

IIf([Milestone];IIf([% Complete]<100;IIf([Finish]>[Baseline Finish];IIf([Baseline Finish]<Now();Yes;No);No);No);No)

(With US settings you need , instead of ;)

Not done, later than the baseline, which in turn is before today.

Greetings,

Sunday, February 12, 2012 7:34 AM