Auto color change on task bars.

D

Dan @ Hess

I am importing scheduling data from MS Access to Project. The data I am
transfering includes information on the "working status" of a given task.
(i.e. lead, working, completed, etc.) I would like each of these to be
represented by a different task bar color. More importantly, I would like
Project to recognize the "working status" and automatically change the task
bar color when I merge the data. Is there a task map (import wizard) that
will accomplish this?
 
J

Jan De Messemaeker

Hi,

You will have to put a formula in a number of task flag fields that put the
flag
"On" when the text field representing the status has a certain value.
Than through the Bar Styles window you can create Bars dependent on these
flag fields similar to the example in
http://www.mvps.org/project/faqs.htm
faq 31. Customizing Task Bars

HTH
 

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

Similar Threads

Gantt task bars not printing 2
Missing task list row and columns Lines along with Ganttchart non working day color 0
Master Schedule - Formatting Gant Chart Task Bars 0
Formatting task bars 4
multiple task bars in one row, Part II 6
Start dates of tasks not changing based on predessesors 1
Draw task bars in relation to slack on detailed gantt 3
Change Working Days to Calendar Days without Impacting the Task Dates 1

Top