Highlight on Date Problem

  • Thread starter Thread starter Lise
  • Start date Start date
L

Lise

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?
 
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
 
Hi Fred

Yes the year is correct 2010. Only happening on month of September - very
annoying.
 
There's got to be something we're not seeing. When you format I54 to
General, what's the number that gets displayed?

Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Highlight cell on certain dates 14
Excel Highlighting duplicates 0
[Flashing] RED before renewal date 1
Conditional formatting dates 2
conditional formating dates, please help me 1
conditional formatting date and blank cell 3
conditional formatting 3
conditional formatting based on a different cell 2

Back
Top