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

Excel Highlighting duplicates 0
conditional formatting date and blank cell 3
Conditional Formatting Applied when Statement Not True 6
Conditional Formatting Dates 1
Date Calculation & Conditional Formatting 3
Highlight on Date Problem 3
Conditional formatting of date-cell - 2007 5
Conditional Format (Todays Date) 2

Top