Colour Coding!

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
Fri Oct 28 04:33:01 CDT 2005

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" <NEvans8993@discussions.microsoft.com> schreef in bericht
news:173EBEAA-EA1C-4133-BF32-15C68ED72481@microsoft.com...
> 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

NEvans8993
Fri Oct 28 04:43:04 CDT 2005

Many thanks for your help.

"Jan De Messemaeker" wrote:

> 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" <NEvans8993@discussions.microsoft.com> schreef in bericht
> news:173EBEAA-EA1C-4133-BF32-15C68ED72481@microsoft.com...
> > 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
>
>
>

NEvans8993
Fri Oct 28 04:50:03 CDT 2005

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" wrote:

> 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" <NEvans8993@discussions.microsoft.com> schreef in bericht
> news:173EBEAA-EA1C-4133-BF32-15C68ED72481@microsoft.com...
> > 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
Fri Oct 28 07:31:25 CDT 2005

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
"NEvans8993" <NEvans8993@discussions.microsoft.com> schreef in bericht
news:F88E9CC1-1C77-4E0E-9A99-DB1F917283AA@microsoft.com...
> 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" wrote:
>
> > 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" <NEvans8993@discussions.microsoft.com> schreef in bericht
> > news:173EBEAA-EA1C-4133-BF32-15C68ED72481@microsoft.com...
> > > 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
> >
> >
> >

NEvans8993
Fri Oct 28 09:41:02 CDT 2005

Excellent. Thanks

"Jan De Messemaeker" wrote:

> 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
> "NEvans8993" <NEvans8993@discussions.microsoft.com> schreef in bericht
> news:F88E9CC1-1C77-4E0E-9A99-DB1F917283AA@microsoft.com...
> > 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" wrote:
> >
> > > 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" <NEvans8993@discussions.microsoft.com> schreef in bericht
> > > news:173EBEAA-EA1C-4133-BF32-15C68ED72481@microsoft.com...
> > > > 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
> > >
> > >
> > >
>
>
>