Graphic Indicators

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