none
Color Cell By %complete RRS feed

  • Question

  • I would like to be able to have the %complete fields automatically change from green to yellow to red based on a percent completed.

    Thanks in advance

    Tuesday, May 16, 2017 5:40 PM

All replies

  • Hi,

    This is not possible as is. I would suggest to create a custom field with a formula returning a graphical indicator with a colored flag, circle, smiley. For example, if %complete<25%, then red, <50% then orange, <75% then yellow, 100% then green.

    See below fro setting graphical indicators:

    • https://support.office.com/en-us/article/Add-indicators-09ee6a60-e171-431a-8e1d-58adc2a317cf
    • https://ntrajkovski.com/2015/02/16/how-to-create-graphic-indicator-for-task-status-in-ms-project-2013/
    • https://www.advisicon.com/2015/03/25/creating-graphical-indicators-based-on-formulas-with-ms-project/

    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller

    Tuesday, May 16, 2017 6:03 PM
    Moderator