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