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.
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 "JM" a écrit dans le message de news: EC2C7348-7C6A-4619-AA68-153055CF4EA9@microsoft.com... > 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.
