How to view assignments that are slipping

[jc]

Good Morning:

Is there a way to show all assignments that are past the
finish date. For example, if Task1 is 80% complete and
the finish date is less than today's date how can I get
these tasks to show in a different color. Can this be
done automatically in MSProject 2000 or do I need to write
a Macro. If a macro is needed does anyone have an example?

Any help would be very much appreciated.

Thank you.

 

[John]

jc,
A macro is not required unless you want to automate the process with a
single click of a toolbar button. Assignments aren't really "past due"
but completion of tasks can be. You might start by looking at the
pre-set filters available (Project/Filtered For/More Filters). Several
address late tasks generally as compared to Baseline Finish. If one of
the pre-set filters gives you what you need, apply it and select all
tasks. Then go to Format/Text Styles and look for "Highlighted Tasks"
in the "Item to change" selection box. Pick a highlight color and hit
"ok".

Hope this helps.
John

 

[John Beamish]

Conditional colour formatting is not available.

Try this:

1. Insert the Number1 column
2. RightMouseButton on the column header and click on "Customize..." to
display the Customize Fields dialog.
3. Click on the Formula button to display the Formula for Number1 dialog.
4. Paste the line below into the formula box
IIf(ProjDateDiff(Finish,now())>0,[% Work Complete],0)
5. Click ok
6. Click on the Graphical Indicators button
7. You will see a grid with three columns "Test for number 1",
"Value(s)", Image.
line1 gets: "equals", 0, green light
line2 gets: "is less than", 50, red light
line3 gets: "is less than", 101, yellow light
8. Click on OK twice

This will display:
* a yellow warning if the finish was scheduled before today and the %Work
Complete is less than 101% and more than 50.
* a red warning if the finish was scheduled before today and the %Work
Complete is less than 50%.

In other words, tasks which should have been finished by today will have
either a red or yellow light.

You can modify the parameters to suit your requirements.

Remember, too, that in step7, Project evaluates the conditions until it
finds the first match and chooses the indicator based on that first match
so arrange your tests in the correct sequence.

JLB, PMP

Good Morning:

Is there a way to show all assignments that are past the
finish date. For example, if Task1 is 80% complete and
the finish date is less than today's date how can I get
these tasks to show in a different color. Can this be
done automatically in MSProject 2000 or do I need to write
a Macro. If a macro is needed does anyone have an example?

Any help would be very much appreciated.

Thank you.

--