Macros!!!

[karishma]

hi
I am using MS Project 2003. in my project i have added a column of Physical
% complete, and in my gantt chart view I want to show a bar only for those
task for which i have added 100% in Physical % complete in one colour. for
those task which are still in progress i want to show them in different
colour.

for this i have added two columns, Flag 1 & Flag 2. but i dont want to
change Yes or No everytime I enter 100% in Physical % Complete column. I have
also set a macro:

IIf([Physical % Complete]=IsNumeric("100%"),"No","Yes"), but it gives yes
for all those task which have value grater than 0% in physical % complete
column.

can anyone please help me to set this macro?

hope its clear to understand.
Thanks

 

[karishma]

yes, you are right.

I have set the formula in custom flag field and i have have whatever I
wanted to have Flag 1 and Flag 2 fields.

but I have one more question regaring the formating of Gantt Bars.
in one of my projects i have list of all othe projects with their start and
finish dates, also i have shown all of them as milestones and rolled-up them
to summary bar. i have shown the names of those projects on summary bar. now
what i want is to differentiate the text colour of those projects on summary
bar as ther are too many of them it looks like all massed-up and overlapping
text. i have manipulated the time sclae and break-up those project in small
groups, but even then i want them in different colour text. is it possible? I
hope my doubt is clear.

You have not set a macro.
You have written a formula in a custom Flag field.

Shouldn't it be in Flag1:
IIf([Physical % Complete]="100%","yes","no")
?

Then Format, Bar Styles, the add a row, lower in the list than the normal
Task, for a new style.
The condition or criteria in the 3rd column is "Normal,Flag1", with whatever
colour you like.

Trevor Rabey 0407213955 61 8 92727485 PERFECT PROJECT PLANNING
www.perfectproject.com.au

hi
I am using MS Project 2003. in my project i have added a column of
Physical
% complete, and in my gantt chart view I want to show a bar only for those
task for which i have added 100% in Physical % complete in one colour. for
those task which are still in progress i want to show them in different
colour.

for this i have added two columns, Flag 1 & Flag 2. but i dont want to
change Yes or No everytime I enter 100% in Physical % Complete column. I
have
also set a macro:

IIf([Physical % Complete]=IsNumeric("100%"),"No","Yes"), but it gives yes
for all those task which have value grater than 0% in physical % complete
column.

can anyone please help me to set this macro?

hope its clear to understand.
Thanks