Why is my conditional formatting highlighting the wrong dates?
 

I have conditional formatting set up in my sheet that highlights any date
less than today. (dates in the past) It works well for most of the sheet but
in some cells, it highlights regardless of the date entered. What am I doing
wrong and how can I fix it?

Thanks!

Why is my conditional formatting highlighting the wrong dates?
 

Are the dates in those bad cells really dates or just text that look like
dates?

If not real dates, they will always be earlier than today.


Gord Dibben MS Excel MVP

On Fri, 3 Apr 2009 13:08:01 -0700, lulabirdy10
wrote:

I have conditional formatting set up in my sheet that highlights any date
less than today. (dates in the past) It works well for most of the sheet but
in some cells, it highlights regardless of the date entered. What am I doing
wrong and how can I fix it?

Thanks!