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

For Red:

Condition1:
Formula Is =AND(ISNUMBER(A1),A1=15)

For Green:
Condition2
Formula Is =AND(ISNUMBER(A1),A1<15)


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=58335

Thank you,

How do I link both formulas to the same cell?

Thanks Mark

"Mark" wrote:

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.
--
David Biddulph

"Mark" wrote in message
...
Thank you,

How do I link both formulas to the same cell?

Thanks Mark

"Mark" wrote:

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

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

"Mark" wrote:

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