Colour Coding!

[NEvans8993]

Hi there,

I have recently set up a Project in the 2003 version, to track all
development jobs passing through the IT department. I have set up a
customised field which has a drop down listing, of items such as , 'To Be
Quoted, In Progress, On Hold, LIVE, Cancelled......etc'. What i am trying to
achieve is that when i select a particular value from the drop down list, i
want the relevant Gantt bar to change colour. I have tried to do this from
within the 'bar styles', dialog box, but it doesn't seem to be able to cater
for criteria such as 'If 'Ref Status', equal to 'LIVE', (then colour should
be set to Green)! etc.

Any help would be greatly appreciated.

Kind Regards
Nicholas J H Evans

 

[Jan De Messemaeker]

Hi,

Bar Colours can react to the boolean value of flag fields
You can set the values of flag fields through a formula
You can read more about this is
http://www.mvps.org/project/faqs.htm
Faq 31. Customizing task bars

HTH

 

[NEvans8993]

Many thanks for your help.

Hi,

Bar Colours can react to the boolean value of flag fields
You can set the values of flag fields through a formula
You can read more about this is
http://www.mvps.org/project/faqs.htm
Faq 31. Customizing task bars

HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620

 

[NEvans8993]

Hi there,

I have just created the following formula, but project didn't seem to like
the ,/OK/OK/OK command, so i took them out, and now the flag field is set to
Yes for all tasks even when the value of [Text2] is not any of the below!

IIf([Text2]="In Progress" Or "Unit Amends to do" Or "UAT Amends to do" Or
"To Be Quoted",Yes,No)

 

[Jan De Messemaeker]

Hi,

I tried the following and it worked:
Iif (condition1, Yes, No) OR Iif(condition2, Yes,No)
HTH


--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620

Hi there,

I have just created the following formula, but project didn't seem to like
the ,/OK/OK/OK command, so i took them out, and now the flag field is set to
Yes for all tasks even when the value of [Text2] is not any of the below!

IIf([Text2]="In Progress" Or "Unit Amends to do" Or "UAT Amends to do" Or
"To Be Quoted",Yes,No)

Hi,

Bar Colours can react to the boolean value of flag fields
You can set the values of flag fields through a formula
You can read more about this is
http://www.mvps.org/project/faqs.htm
Faq 31. Customizing task bars

HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
trying
to list,
i

 

[NEvans8993]

Excellent. Thanks

Hi,

I tried the following and it worked:
Iif (condition1, Yes, No) OR Iif(condition2, Yes,No)
HTH


--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620

Hi there,

I have just created the following formula, but project didn't seem to like
the ,/OK/OK/OK command, so i took them out, and now the flag field is set to
Yes for all tasks even when the value of [Text2] is not any of the below!

IIf([Text2]="In Progress" Or "Unit Amends to do" Or "UAT Amends to do" Or
"To Be Quoted",Yes,No)

Hi,

Bar Colours can react to the boolean value of flag fields
You can set the values of flag fields through a formula
You can read more about this is
http://www.mvps.org/project/faqs.htm
Faq 31. Customizing task bars

HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"NEvans8993" <[email protected]> schreef in bericht
Hi there,

I have recently set up a Project in the 2003 version, to track all
development jobs passing through the IT department. I have set up a
customised field which has a drop down listing, of items such as , 'To Be
Quoted, In Progress, On Hold, LIVE, Cancelled......etc'. What i am trying
to
achieve is that when i select a particular value from the drop down list,
i
want the relevant Gantt bar to change colour. I have tried to do this from
within the 'bar styles', dialog box, but it doesn't seem to be able to
cater
for criteria such as 'If 'Ref Status', equal to 'LIVE', (then colour
should
be set to Green)! etc.

Any help would be greatly appreciated.

Kind Regards
Nicholas J H Evans