Coonditional formatting

[Mark]

I set conditional formatting:

If Cell is greater than 15 shade red

add

If cell is less than 15 shade green


It says green no matter what I do


Any ideas?

Number is difference in dates

 

[Mark]

Thank you,

How do I link both formulas to the same cell?

Thanks Mark

 

[David Biddulph]

Within Conditional formatting, set the first condition and its format, then
hit the Add button, & add the second condition & its format.

 

[Mark]

Ok I figured out what you meant here,

However, once I turn C7 red....No matter what I change the date to (less
than 15) it will NOT change back to green It stays defaulted to Green or Red
whichever comes in 1st.

Any ideas why.

The number is the difference in dates if that mattetters ie; 01/01/2009 -
01/11/2009