Auto colouring ( RAG ) tasks based upon % complete to due date in MS project 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.       Late

    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? thx

    Friday, December 2, 2016 7:29 PM

All replies

  • maumc,

    I assume you want to change the font color of the whole task row depending on which status item is selected in the custom field. it's pretty easy to create a formula to change the Gantt Bar colors corresponding to the value selected but unfortunately not the text font color. To do what you want would require some VBA, either run after all selections are made or using a Change Event configured to respond the custom field setting.


    Friday, December 2, 2016 9:01 PM