From: McDan on
I would like to create a graphical indicators to show this information:

If task is late less than 2 weeks - green sign;
If task is late within 2-4 weeks - yellow sign;
If task is late more than 4 weeks - red sign

Do I need a formula for this ?
From: Jan De Messemaeker on
Hi,

Depends how you define late. Whet exactlly do you mean? Late compated to
what?

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
"McDan" <McDan(a)discussions.microsoft.com> wrote in message
news:713FB208-224B-4BFC-B80F-955ADD9BF649(a)microsoft.com...
>I would like to create a graphical indicators to show this information:
>
> If task is late less than 2 weeks - green sign;
> If task is late within 2-4 weeks - yellow sign;
> If task is late more than 4 weeks - red sign
>
> Do I need a formula for this ?


From: Jim Aksel on
You may want to read my white papers regarding "What Percent Complete Should
I Be?". They are on my blog, link is below. I have another paper on Red
Amber and Green (RAG or Stoplights) as well.
--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com



"McDan" wrote:

> I would like to create a graphical indicators to show this information:
>
> If task is late less than 2 weeks - green sign;
> If task is late within 2-4 weeks - yellow sign;
> If task is late more than 4 weeks - red sign
>
> Do I need a formula for this ?
From: Trevor Rabey on
How do you define late?
Depending on whether a task is critical, or close to being critical,
"lateness", however defined, may or may not be anything to be concerned
about.
Not everything is urgent, or has to finish on or before its late finish.

These traffic lights and RAG indicators are just eye candy.
They are not very informative or useful.
--
Trevor Rabey
0407213955
61 8 92727485
PERFECT PROJECT PLANNING
www.perfectproject.com.au

"McDan" <McDan(a)discussions.microsoft.com> wrote in message
news:713FB208-224B-4BFC-B80F-955ADD9BF649(a)microsoft.com...
>I would like to create a graphical indicators to show this information:
>
> If task is late less than 2 weeks - green sign;
> If task is late within 2-4 weeks - yellow sign;
> If task is late more than 4 weeks - red sign
>
> Do I need a formula for this ?