Highlight on Date Problem
 

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

Highlight on Date Problem
 

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" wrote in message
...
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

Highlight on Date Problem
 

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" wrote in message
...
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

.

Highlight on Date Problem
 

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" wrote in message
...
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" wrote in message
...
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

.