Help Task Overdue Indicator Formula

[Friz]

Can someone help me with the formula for Task Overdue. I
am trying to create an Overdue Indicator with these rules:
Red Indicator
If a task's is not completed and the Projected Finish
Date is 30 Days Past today's date.
Yellow Indicator
If a task's is not completed and the Projected Finish
Date is 15 Days Past today's date.
Green Indicator
All other cases

Here is my initial formula just to get started to see it
is one day overdue but this formula does not work:
IIf((Left(Trim([% Complete]),3)<100) And (ProjDateDiff
([Finish],Now()/480>=1)),1,0)

Then the graphical indicator checks if 1 then show red
and if 0 show green (ie meaning not overdue by one day)

If anyone could help me the correct formula I would
greatly appreciate it!!!

 

[Naveen]

Try thi

Switch ( ([% Complete] < 100) AND (ProjDateDiff([Finish], Now())/480 > 30), "Red", ([% Complete] < 100) AND (ProjDateDiff([Finish], Now())/480 > 15), "Yellow", True, "Green"

Cheers