I'm sorry that I didn't write A3, but I see ,you see the problem and I hear
you, that one overides the other.

But if I change the date in A2 and it changes A3 to</14 Is there no
conditional formula that will work to make it red/green based on </14?

thanks pete

very much

"Pete_UK" wrote:

So why did you quote A1 in the formula that you gave in your first
post?

I suggest you check that those formulae actually refer to A3.

Anyway, you have an overlap on those conditions. The first one (which
takes priority) is looking for values greater than or equal to 14,
whereas the second one is less than 15, so the first criteria will
always apply if the number is 14.

Hope this helps.

Pete

On Feb 4, 7:10 pm, Mark wrote:
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- Hide quoted text -

- Show quoted text -