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

[Robert94]

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?

[#2 · Accepted solution]

@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