Hi,

Seems that you want the conditional occur only on cell A3. What I can see
is:-
A1 contains a date 01/01/2009
A2 contains a date 01/22/2009
A3 contains the different of how many days when you subtract date A1 from A2
" =A2-A1". And this cell must come with conditional format if the day
equal
to less then or equal to 14 should turns red and if it is greater than
or equal to
15 should turns green.

Suggestions:

1) Firstly, Try the following conditional formats and apply them to cell A3:
Conditions 1: (Red)
=AND(ISNUMBER(A3),DAY(A3)<=14)

Conditions 2: (Green)
=AND(ISNUMBER(A3),DAY(A3)=15)

2) Secondly, make sure font format in cell A3 not formated as "Red" or
"Green" in color.

3) Lastly, make sure you have entered a valid date in cell A1 and A2.
(d/m/yyyy or m/d/yyyy)

4) Ok, finally, probably you should try any of these formula instead and put
it in cell A3.
=ABS(A1-A2)
or
=Datedif(A1,A2,"md")

Regards.

"Mark" wrote in message
...
A1 contains a date 01/01/2009
A2 contains a date 01/22/2009

A3 would be the difference in that date (turns red)

I set conditonal in A3 if equal to or less than 14 turn green
Add....If greather than 14 turn red.

Whichever color comes up 1st in A3 be it a red number or green, the other
conditon does NOT change if I change the date in A2 to )1/03/2009 or (2)
it
should turn green but it stays red.. It stays at the 1st color associated
with the 1st date entered in A2 . Even if I F9 or shift F9 with a new date
in
A2 the color will not change from whatever came in 1st.

Thanks

A1 = 01/01/2009
A2 = 01/10/2009


"Mark" wrote:

For Red:

Condition1:
Formula Is =AND(ISNUMBER(A1),A1=14)

For Green:
Condition2
Formula Is =AND(ISNUMBER(A1),A1<15)

If I put in 01/01/2009 - 01/21/2009 cell DOES turn red.

If I change the second date(01/21/2009) (20days) to 1/04/2009 ( 3 days)
the
cell Stays RED
or if I have a green cell IT STAYS GREEN when the dates are altered.. Is
this a one time shot?..

Any ideas

And I apologise if I have posted this more than once . I am over my head
and
have reached out on 3 topics...

Thanks for understanding Mark