I want a project 2007 template modified to show dates and gantt bars in color based on the status.
If status field = "on schedule" color is green, Status = "future task" color is blue, status = "late" color is red
I also want instructions show exactly how you did it
I will provide a project 2007 template for you to work with
Had another lancer try to do this and he said it could not be done. Says that I should make certain to state that it is to be done automatically.
Automatically means, when the file is opened the dates and bars change to the color based on the status field.I do not need to click on a button for each task to change its color.
On a side note.
If you simply want to make it so, if %complete is <100 and finish date is <=today bar and a traffic light color = red, and then the same type formula for the other colors that would be ok also, just quote accordingly
Here is an article that if it works would be good
[url removed, login to view]