What does A1 actually contain?

Pete

On Feb 4, 5:03*pm, 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