Prev: emailing worksheet...
Next: How do I make a graph with 2 "Y-Axes" at different scale?
From: Lise on 3 May 2010 18:15
Hi everyone

I have the following in conditional format in column A

=I54-TODAY()<=60 if true highlight Red

This is working in most cases but for some reason when september dates are
in the I column they also highlight red which is incorrect - am I missing
something in the formula please?
--
Thanks as always

Lise
From: Fred Smith on 3 May 2010 18:56
Your formula is valid. An incorrect year will cause the problem stated. Are
you entering 2010, as opposed to 2009, or even 1910?

Regards,
Fred

"Lise" <Lise(a)discussions.microsoft.com> wrote in message
news:06189BDF-CAD4-4BA8-BAAB-8DA2377CF242(a)microsoft.com...
> Hi everyone
>
> I have the following in conditional format in column A
>
> =I54-TODAY()<=60 if true highlight Red
>
> This is working in most cases but for some reason when september dates are
> in the I column they also highlight red which is incorrect - am I missing
> something in the formula please?
> --
> Thanks as always
>
> Lise

From: Lise on 4 May 2010 17:24
Hi Fred

Yes the year is correct 2010. Only happening on month of September - very
annoying.
--
Thanks as always

Lise


"Fred Smith" wrote:

> Your formula is valid. An incorrect year will cause the problem stated. Are
> you entering 2010, as opposed to 2009, or even 1910?
>
> Regards,
> Fred
>
> "Lise" <Lise(a)discussions.microsoft.com> wrote in message
> news:06189BDF-CAD4-4BA8-BAAB-8DA2377CF242(a)microsoft.com...
> > Hi everyone
> >
> > I have the following in conditional format in column A
> >
> > =I54-TODAY()<=60 if true highlight Red
> >
> > This is working in most cases but for some reason when september dates are
> > in the I column they also highlight red which is incorrect - am I missing
> > something in the formula please?
> > --
> > Thanks as always
> >
> > Lise
>
> .
>
From: Fred Smith on 5 May 2010 09:25
There's got to be something we're not seeing. When you format I54 to
General, what's the number that gets displayed?

Fred

"Lise" <Lise(a)discussions.microsoft.com> wrote in message
news:36A17522-3790-4E5D-BDBC-3858701F3B12(a)microsoft.com...
> Hi Fred
>
> Yes the year is correct 2010. Only happening on month of September - very
> annoying.
> --
> Thanks as always
>
> Lise
>
>
> "Fred Smith" wrote:
>
>> Your formula is valid. An incorrect year will cause the problem stated.
>> Are
>> you entering 2010, as opposed to 2009, or even 1910?
>>
>> Regards,
>> Fred
>>
>> "Lise" <Lise(a)discussions.microsoft.com> wrote in message
>> news:06189BDF-CAD4-4BA8-BAAB-8DA2377CF242(a)microsoft.com...
>> > Hi everyone
>> >
>> > I have the following in conditional format in column A
>> >
>> > =I54-TODAY()<=60 if true highlight Red
>> >
>> > This is working in most cases but for some reason when september dates
>> > are
>> > in the I column they also highlight red which is incorrect - am I
>> > missing
>> > something in the formula please?
>> > --
>> > Thanks as always
>> >
>> > Lise
>>
>> .
>>

 | 
Pages: 1
Prev: emailing worksheet...
Next: How do I make a graph with 2 "Y-Axes" at different scale?