I would like to have graphiic indicators for:
Red where the task has slipped for the curent date and
Green where the task is completed or on track.

Hello Olufemi,

Thank you for an interesting question

The first thing you need to do is create a custom field that checks to see if the task has any variance in either it's start date or it's end date.

Click on Tools-Customise-Fields and then choose one of the number fields and click on the formula button.

Then enter the following

IIf([Start Variance]<>0 Or [Finish Variance]<>0,1,0)

This uses the immediate if function and checks to see if either the start date or the end date has any variance from the baseline. If it does it returns the value 1, otherwise 0.

Having created the function click on the graphical indicators button and select a red light for the value 1 and a green light for the value 0.

Hopefully this resolves your problem. If you require further refinement, please let me know

Regards

Stephen

Thanks Stephen,

I do require further refinement. I will like it to also indicate RED for here the task has slipped. I added the progress line at the currect date and this shows slipped tasks, but I would like the graphic indicator to show red for the slipped tasks also.

Thanks
Femi