Prev: Using match but data needs to be split.
Next: How do I stop text from disappearing when I wrap text in Excel?
From: Stefi on 23 Mar 2010 06:06
Change the order of the three conditions like this:

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

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

> =AND($B$12<>"",$B$12>TODAY()+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$12>TODAY()+60)
> Formats to pink background
>
> =AND($B$12<>"",$B$12>TODAY()+120)
> Formats to a yellow background
>
> =AND($B$12<>"",$B$12>TODAY()+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.
First  |  Prev  | 
Pages: 1 2
Prev: Using match but data needs to be split.
Next: How do I stop text from disappearing when I wrap text in Excel?