Automatic colour coding of tasks RRS feed

  • Question

  • I am looking at colour coding a customised field in Project 2010 e.g. I have created a field “Project Status”  with the following pick list options

    1.       Not started

    2.       In Progress

    3.       Stalled

    4.       Cancelled

    5.       Completed

    6.       Out of Schedule

    What I am trying to achieve is that on selection of the respective options that an automatic text colour code could be applied  e.g. on selection of the “Completed” option,  then the font would be in Blue or on selection of the “in-progress” option, then the font colour would be green and so on.

    Can anyone advise whether this is possible or not?

    Many thanks

    Monday, August 8, 2011 12:06 PM


All replies

  • Cisco098 --

    Using the default features in Microsoft Project 2010, there is no way to color code tasks based on the value in a custom field.  The only way to address your situations would be through a macro in the VBA programming language.  You might want to repost your question in the following forum and let our software developer friends guide you on how to structure the macro:

    Hope this helps.

    Dale A. Howard [MVP]
    VP of Educational Services
    "We write the books on Project Server"

    Monday, August 8, 2011 12:46 PM
  • Hi Cisco,

    This is only possible through VBA programming. If you want I can set you on the way for such a VBA procedure.

    Conditional coloring of the Bars is possible by using formulas but only if the condition can be derived from the task data. For instance, I fail to see what "stalled" is in terms of MS Project. By all means, lookup more details in   Faq 31 Customizing Task Bars.

    There is another step possible towards your request. If you can define filters for your different conditions, and set the view as "Highlight Filter" you may see the filtered tasks as colored - but the same color for each filter I'm afraid.


    Monday, August 8, 2011 12:47 PM
  • Short of Jan's VBA solution for putting color on tasks based on custom fields you could do graphical indicators on the custom field itself so that if the value was "In Progress" that field would show a Green 'ball' or 'square' and if it were "Stalled" the ball or square would be Red, etc.
    Brian Kennemer – DeltaBahn Senior Architect
    Blog | Twitter | LinkedIn
    Monday, August 8, 2011 5:46 PM