Color graphic indicator

[Chanel DR]

I see many useful tips on the board about creating a color graphic indicator.
However, what I am looking for, and I may not seeing it, is a simple formula
for MS project professional that shows if finish date is less than deadline
it is green, if finish date is greater than deadline it is red, if task is
100% complete, it is blue.

It would be great to have a formula that can track by, if finish date is
less than deadline but % complete is less than 80% turn it amber.

If there is such a formula on the board, could anyone direct me? If not,
does anyone have any suggestions?

Thank you,

 

[Gérard Ducouret]

Chanel Dr,

You could use a formula like this one:
IIf([Finish]<[Dealine] And [% Complete]<80,"less than deadline but %
complete is less than 80%","More than deadline OR more than 80% ")
Inset a Text(x) field such as Texte1, then
Tools / Customize / Fields...
Formula : the above formula, with strings a little shorter than mine ;-)
Graphical indicator :
- Test for Text1; Equals "First string"; Image : yellow smiley...

Hope this helps,

Gérard Ducouret