Color 'active' tasks

[Onno]

Hello,

Is it possible for the bars in the gantt chart to have a different
color based on the current date & resource assignment?

A worker in my project asked this: "Isn't it possible to have the task
I should be working on this week to have a different color?"

Thanks
Onno Willems

 

[JulieS]

Hello Onno,

In addition to Trevor's suggestion and directions that directly
answer your question, have you considered filtering the list to only
show tasks for the specific resource? If you are printing a view,
applying the already made "Using Resource in Date Range" filter
before printing can be a possible solution .

As Trevor also noted, there is an FAQ on the Project MVP website
that I think you'll find helpful. See FAQ 31 at
http://project.mvps.org/faqs.htm

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

"Onno" wrote in message
news:[email protected]...

 

[vanita]

Hi Onno

Going ahead with Julie's advise, you may use the 'using resource with date
range' filter wirh highlight. That ways you will view all the tasks, but only
the tasks using a resource within a date range would appear in Blue colour.
Ofcourse it won't make any changes in the bar colour.

I hope it helps
Vanita

 

[vanita]

Hi Julie

I have used the formula given in the FAQ 31. The formula is not accepted
with last three OK. Without those OK the formula is accepted with respect to
a particular resource, but it works only for those tasks which have only this
particular resource assignment and not in combination with other resources.

For example, if I use this formula IIf( [Resource Names], Yes, No ) and
apply it for resource 'Masons', 'Yes' would appear only for those tasks to
which only 'Masons' are assigned, but not for those tasks, to which 'Masons'
as well as 'Plumbers' might be assigned.

In your view is there any way to work around this problem, apart from VBA
application.

Vanita

 

[Onno]

Hi All,

Thanks for your suggestions!
I've decided to go with Julie's suggestion of using a filter (I didn't
even see that option yet, whoops

Thanks for the help!
Onno

 

[JulieS]

Hi Vanita,

My comments are inline>

Hi Julie

I have used the formula given in the FAQ 31. The formula is not
accepted
with last three OK.

The formula does not include the three "ok"s. The formula is:
IIf([Resource Names] = "Fred", Yes, No)

The okays are to first close the Formula dialog box , then close the
Customize Fields dialog box.

Without those OK the formula is accepted with respect to
a particular resource, but it works only for those tasks which
have only this
particular resource assignment and not in combination with other
resources.

For example, if I use this formula IIf( [Resource Names], Yes,
No ) and
apply it for resource 'Masons', 'Yes' would appear only for those
tasks to
which only 'Masons' are assigned, but not for those tasks, to
which 'Masons'
as well as 'Plumbers' might be assigned.

In your view is there any way to work around this problem, apart
from VBA
application.

Instead of the formula listed in FAQ 31, you might try this formula:

IIf(Instr([Resource Names],"Masons")>0,Yes,No)

It uses the Instr function which tests a string ([Resource Names])
for a string "Masons" and returns the position of the "masons"
string in the Resource Names fields. The Instr function returns the
position of the second string in the first string. If the position
is greater than zero, I know "masons" exists in the Resource Names
field. That function is a bit more flexible than the function in
the FAQ.

 

[vanita]

Thanks Julie. It worked well.

Vanita
--
Project Management consultant and trainer
(e-mail address removed)

Hi Vanita,

My comments are inline>

Hi Julie

I have used the formula given in the FAQ 31. The formula is not
accepted
with last three OK.

The formula does not include the three "ok"s. The formula is:
IIf([Resource Names] = "Fred", Yes, No)

The okays are to first close the Formula dialog box , then close the
Customize Fields dialog box.

Without those OK the formula is accepted with respect to
a particular resource, but it works only for those tasks which
have only this
particular resource assignment and not in combination with other
resources.

For example, if I use this formula IIf( [Resource Names], Yes,
No ) and
apply it for resource 'Masons', 'Yes' would appear only for those
tasks to
which only 'Masons' are assigned, but not for those tasks, to
which 'Masons'
as well as 'Plumbers' might be assigned.

In your view is there any way to work around this problem, apart
from VBA
application.

Instead of the formula listed in FAQ 31, you might try this formula:

IIf(Instr([Resource Names],"Masons")>0,Yes,No)

It uses the Instr function which tests a string ([Resource Names])
for a string "Masons" and returns the position of the "masons"
string in the Resource Names fields. The Instr function returns the
position of the second string in the first string. If the position
is greater than zero, I know "masons" exists in the Resource Names
field. That function is a bit more flexible than the function in
the FAQ.

 

[JulieS]

You're welcome Vanita. I'm glad the modification suited your needs.
Thanks for the feedback.

Julie

Thanks Julie. It worked well.

Vanita
--
Project Management consultant and trainer
(e-mail address removed)

Hi Vanita,

My comments are inline>

Hi Julie

I have used the formula given in the FAQ 31. The formula is not
accepted
with last three OK.

The formula does not include the three "ok"s. The formula is:
IIf([Resource Names] = "Fred", Yes, No)

The okays are to first close the Formula dialog box , then close
the
Customize Fields dialog box.

Without those OK the formula is accepted with respect to
a particular resource, but it works only for those tasks which
have only this
particular resource assignment and not in combination with
other
resources.

For example, if I use this formula IIf( [Resource Names], Yes,
No ) and
apply it for resource 'Masons', 'Yes' would appear only for
those
tasks to
which only 'Masons' are assigned, but not for those tasks, to
which 'Masons'
as well as 'Plumbers' might be assigned.

In your view is there any way to work around this problem,
apart
from VBA
application.

Instead of the formula listed in FAQ 31, you might try this
formula:

IIf(Instr([Resource Names],"Masons")>0,Yes,No)

It uses the Instr function which tests a string ([Resource
Names])
for a string "Masons" and returns the position of the "masons"
string in the Resource Names fields. The Instr function returns
the
position of the second string in the first string. If the
position
is greater than zero, I know "masons" exists in the Resource
Names
field. That function is a bit more flexible than the function in
the FAQ.

Vanita
--
Project Management consultant and trainer
(e-mail address removed)



:

Hello Onno,

In addition to Trevor's suggestion and directions that
directly
answer your question, have you considered filtering the list
to
only
show tasks for the specific resource? If you are printing a
view,
applying the already made "Using Resource in Date Range"
filter
before printing can be a possible solution .

As Trevor also noted, there is an FAQ on the Project MVP
website
that I think you'll find helpful. See FAQ 31 at
http://project.mvps.org/faqs.htm

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

"Onno" wrote in message
Hello,

Is it possible for the bars in the gantt chart to have a
different
color based on the current date & resource assignment?

A worker in my project asked this: "Isn't it possible to
have
the
task
I should be working on this week to have a different color?"

Thanks
Onno Willems

 

[JulieS]

You're most welcome Onno. Glad to have helped and thanks for the
feedback.

Julie

"Onno" wrote in message
news:8934cdb9-df33-451d-b59d-c3378404a8e5@f19g2000yqh.googlegroups.com...