Why is my conditional formatting highlighting the wrong dates?

L

lulabirdy10

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!
 
G

Gord Dibben

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
 

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

Conditional formatting with dates 7
Document Merge Formatting Issue 0
error in highlighting duplicate values in excel 1
Conditional Formatting in Excel 2003 2
Conditional Formatting Dates Less Than 14 Years Ago 2
Conditional formatting with two columns 0
if then and conditional formatting of dates 3
Excel Date Formatting 0

Top