Forum Discussion

Robert94's avatar
Robert94
Copper Contributor
Feb 16, 2024

Formula for Native Color indicators for Finish date in Microsoft Project for the Web?

Hi,

Does anyone know what is the exact formula of the Finish date, for it to turn yellow? I know the conditon to turn red is for the date to simply be in the past, but for the date to become yellow there is no document that states exactly how and when it happens.

Any help?

 

  • Robert94 I did a little testing, and this is what I experienced.

    • Task is marked 100% complete, no coloring
    • Task is NOT start or completed and Finish date is greater than current date, no coloring
    • Task is NOT started or completed and Finish date is earlier than current date, coloring is red
    • Task Finish date equal to current date, Finish date displays Today with light yellow coloring
  • RodFromm's avatar
    RodFromm
    Steel Contributor

    Robert94 I did a little testing, and this is what I experienced.

    • Task is marked 100% complete, no coloring
    • Task is NOT start or completed and Finish date is greater than current date, no coloring
    • Task is NOT started or completed and Finish date is earlier than current date, coloring is red
    • Task Finish date equal to current date, Finish date displays Today with light yellow coloring

Resources