Change the order of the three conditions like this:

=AND($B$12<"",$B$12TODAY()+180)
Formats to a green background

=AND($B$12<"",$B$12TODAY()+120)
Formats to a yellow background

=AND($B$12<"",$B$12TODAY()+60)
Formats to pink background

If the first condition evaluates to True, the other two will NOT be
evaluated!

--
Regards!
Stefi



€žCbeckwith€� ezt Ã*rta:

This formula is just giving me "Pink" color on background no matter what date
I give it in the b12

=AND($B$12<"",$B$12TODAY()+60)
Formats to pink background

=AND($B$12<"",$B$12TODAY()+120)
Formats to a yellow background

=AND($B$12<"",$B$12TODAY()+180)
Formats to a green background

According to what I see, it should give me the different colors depending.





"Mike H" wrote:

Hi

The formula will evaluate as TRUE or FALSE and is checking 2 conditions
which must both be TRUE

=AND($B$12<"",$B$12<TODAY()+120)

the AND is the bit that ensure both must be true to return TRUE

Condition 1 checks that B12 has data in the cell i.e < means 'does not equal'
$B$12<""


Condition 2 checks that the date in the cell is less than (<) 120 days in
the future
$B$12<TODAY()+120

The reason condition 1 is required is that B12 would evaluate as zero if it
was empty and cause the formula to evaluate as TRUE
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Cbeckwith" wrote:

See below:

Can someone explain the following in simple language;

=AND($B$12<"",$B$12<TODAY()+120)

What does the < after the cell location mean? and why the double quotes ""?
I thought the double quotes meant whatever is in the cell is NULL....I have a
date in the $B$12 position.