Coonditional formatting

  • Thread starter Thread starter Mark
  • Start date Start date
M

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
 
Within Conditional formatting, set the first condition and its format, then
hit the Add button, & add the second condition & its format.
 
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
 
Back
Top