Help with a formula - colour coding late finishes

[JM]

I'm trying to add a formula that provides a colour code eg. red, yellow,
green visual representation if the finish date has past and a task is not
complete.
Can someone help?

Ideally:
Late > 7 days = Red
Late > 1 day = Yellow
On Track = Green

And for any tasks that have not yet start (based on start date), just
display a blank.

 

[Gérard Ducouret]

JM,

Try the formula :
IIf([% Complete]<100,ProjDateDiff([Current Date],[Finish])/[Minutes Per
Day],0)
Copy this formula in a Number field for ex.
Insert / Column : Number1
Right click the header : Customize fields.... / Formula
then Click the Graphical Indicators.. button to set the colors you want
Is less than -7 : Red
Is less than : -1 : Yellow

Gérard Ducouret