Are we assume you have something like
start-date due-date 25%-date 50%-date 75%-date
100%-date
1-Jan-2009 1-Jul-2009 20-Feb-2009 1-Apr-2009 16-May-2009 1-Jul-2009
with labels in row 1 and dates in row 2

Since the 25% date (C2) is late, it should be red
The formula for the Conditional Format dialog is =C2A2+(B2-A2)/4
The rest are similar
=D2A2+(B2-A2)/2
=E2A2+(B2-A2)*(3/4)
=F2A2+(B2-A2) or B2
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"adrian" wrote in message
...
Please help me with a formula, or conditional formatting.

i have the situation: a1 = start date, a2 = due date, and 4 cells with
percentage from done (25%, 50%, 75%, 100%)
i want to do: if the percentage from done is not realised in 25% from
start
date then make red that cell. then do the same for 50%, 75%...

if i wasn't clear enought please tell me.

thanks.

adrian.