Formula

[jp]

Hi,

I'm trying to figure out how to do the following:

Add a custom field to the "Gantt Chart" called "Task_Status".

This "Task_Status" would have a pull down menu of 4 items:
1) Complete
2) Not Complete
3) In Progress
4) Up-coming task

So, if the value is "Complete" from the field called "Task_Status" then the

Task Name column is highlighted in green color. If the task is "Not Complete"

give the "Task Name" column a red color. If it is "In Progress" give it a
yello color

and finally if the task is "Up-coming" do nothing.

Thanks.
-JP

 

[Mike Glen]

Hi JP,

Welcome to this Microsoft Project newsgroup

I suggest you have a look at the Status column and the Status Indicator
column. Try Insert/Column and then hover your mouse over the column heading
for a few seconds and click on the shortcut to Help.

FAQs, companion products and other useful Project information can be seen at
this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for my free Project Tutorials

 

[Jan De Messemaeker]

Hi,

This would be a nice example of a VBA procedure but it can't be done
otherwise... because Task Name is not a custom field thus cannot be
customized :-(
HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[jp]

Mike,

Thanks for the response. I looked at the columns you suggested and they're
pretty good. However, I need to find out how to change the color of the
"task name". How would I do that? Also, do you know where I can get
examples of the functions "IF" & "Switch" functions. Thank you.

-jaime

 

[vanita]

Hi

Have a look at the column 'Status Indicator'. It might be of help. Ofcourse
text colours you will have change yourself.

I hope it helps.
Vanita

 

[Mike Glen]

Hi JP,

Search Help for "Project functions for custom fields"


Mike Glen
Project MVP
See http://tinyurl.com/2xbhc for my free Project Tutorials

 

[jp]

Jan,

So when it comes to built in columns one can not customized them by changing
the color or anything else?

-jp

 

[Dave]

You can't automate it via a formula.

Jan,

So when it comes to built in columns one can not customized them by changing
the color or anything else?

-jp

 

[Jan De Messemaeker]

Hi,

Don't like the expression "Built in": Text1 f.i. is "built in" as well but
it can be customized throiugh formula. But Name, Start, etc? can't. You do
have access to their content and format through VBA.
HTH

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