Milestones with different colors

R

Ric Marshall

A simple question, but I don't know the answer...

In my plan, I want my gantt chart to show completed milestones as green, not
started but not late milestones as blue, and not started but late milesones
as red.

I certainly appreciate any help!
 
G

Gérard Ducouret

Ric,

You have to calculate a Flag field for each kind of milestone, such as :
Flag1 formula : IIf([% Complete]=100;True;False)
To do that : insert the Flag1 field : Insert / Field
Right click the Flag1 header / Customize Field
Formula : IIf([% Complete]=100;True;False)

Then use this Flag field in the Bar Style dialog :
Create a new milestone symbol for the completed milestone (look at the
defalt milsetone symbol)
The only difference besides the color will be in the "Show For " column:
Milestone,Flag1

Hope this helps,

Gérard Ducouret
 
R

Ric Marshall

Gerard (sorry for not knowing how to include the accent :) ),

That worked! Thanks so much! Kudos to you for helping another person!

Gérard Ducouret said:
Ric,

You have to calculate a Flag field for each kind of milestone, such as :
Flag1 formula : IIf([% Complete]=100;True;False)
To do that : insert the Flag1 field : Insert / Field
Right click the Flag1 header / Customize Field
Formula : IIf([% Complete]=100;True;False)

Then use this Flag field in the Bar Style dialog :
Create a new milestone symbol for the completed milestone (look at the
defalt milsetone symbol)
The only difference besides the color will be in the "Show For " column:
Milestone,Flag1

Hope this helps,

Gérard Ducouret


Ric Marshall said:
A simple question, but I don't know the answer...

In my plan, I want my gantt chart to show completed milestones as green, not
started but not late milestones as blue, and not started but late milesones
as red.

I certainly appreciate any help!
 
G

Gérard Ducouret

You are welcome Ric!
Thanks for the feedback!

Gérard

Ric Marshall said:
Gerard (sorry for not knowing how to include the accent :) ),

That worked! Thanks so much! Kudos to you for helping another person!

Gérard Ducouret said:
Ric,

You have to calculate a Flag field for each kind of milestone, such as :
Flag1 formula : IIf([% Complete]=100;True;False)
To do that : insert the Flag1 field : Insert / Field
Right click the Flag1 header / Customize Field
Formula : IIf([% Complete]=100;True;False)

Then use this Flag field in the Bar Style dialog :
Create a new milestone symbol for the completed milestone (look at the
defalt milsetone symbol)
The only difference besides the color will be in the "Show For " column:
Milestone,Flag1

Hope this helps,

Gérard Ducouret


Ric Marshall said:
A simple question, but I don't know the answer...

In my plan, I want my gantt chart to show completed milestones as
green,
not
started but not late milestones as blue, and not started but late milesones
as red.

I certainly appreciate any help!
 
H

Henrik

Old post, but still very helpful...

I've implemented this but have some problems with rolled-up milestones.
There are two problems:

1) For the rolled-up milestone, even though the completion is at 100% the
completion flag remains at "No"

2) The coloring of the bar style for the rolled-up milestone is somewhat
erratic. When all 'sub-milestones' are at 0% completion, the rolled-up
milestone (with a completion % on 0%) appears correctly with the bar style
formatting chosen (as a blue milestone); however if just a single
'sub-milestone' is completed, the rolled-up milestone will appear with the
fomatting I've chosen as complete even though it is only partly completed.
(The completion flag will stay at "No" in both circumstances, as per issue
1). The 'Show For... Tasks" formula I've used is 'Milestone,Rolled
Up,Flag3,Not Summary', with Flag3 being the [non-functioning] completion flag.

Thanks!
Henrik
 
J

John

Henrik said:
Old post, but still very helpful...

I've implemented this but have some problems with rolled-up milestones.
There are two problems:

1) For the rolled-up milestone, even though the completion is at 100% the
completion flag remains at "No"

2) The coloring of the bar style for the rolled-up milestone is somewhat
erratic. When all 'sub-milestones' are at 0% completion, the rolled-up
milestone (with a completion % on 0%) appears correctly with the bar style
formatting chosen (as a blue milestone); however if just a single
'sub-milestone' is completed, the rolled-up milestone will appear with the
fomatting I've chosen as complete even though it is only partly completed.
(The completion flag will stay at "No" in both circumstances, as per issue
1). The 'Show For... Tasks" formula I've used is 'Milestone,Rolled
Up,Flag3,Not Summary', with Flag3 being the [non-functioning] completion flag.

Thanks!
Henrik

Henrik,
I didn't actually run a test case but based on Gerard's suggestions and
what you are seeing here are a couple of things you might want to look
at.

For your first question, make sure you have checked the option in the
custom fields windows to use the formula for summary lines.

One reason you may be seeing erratic behavior with formatting is that
Project's bar styles format works on a hierarchy. The formatting at the
bottom of the formatting list has the highest priority. For example, if
you have formatting for a milestone as the 5th formatting item and also
formatting for a milestone as the 6th formatting item, the latter will
take precedence over the former. Another possibility is that you may
need to add some additional criteria to the "Show For..." column (e.g.
summary).

Hope this helps.

John
Project MVP
Gérard Ducouret said:
Ric,

You have to calculate a Flag field for each kind of milestone, such as :
Flag1 formula : IIf([% Complete]=100;True;False)
To do that : insert the Flag1 field : Insert / Field
Right click the Flag1 header / Customize Field
Formula : IIf([% Complete]=100;True;False)

Then use this Flag field in the Bar Style dialog :
Create a new milestone symbol for the completed milestone (look at the
defalt milsetone symbol)
The only difference besides the color will be in the "Show For " column:
Milestone,Flag1

Hope this helps,

Gérard Ducouret
 
H

Henrik

Fantastic, I clicked the summary box and swapped the bar style formatting
order -- et voilà!

Thanks a lot
Henrik
 
J

John

Henrik said:
Fantastic, I clicked the summary box and swapped the bar style formatting
order -- et voilà!

Thanks a lot
Henrik

Henrik,
You're welcome and thanks for the feedback.

John
Project MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top