Conditional formatting, if not a date

[Laavista]

How do I enter a conditional format to highlight the cell if it's not a valid
date?

I tried "formula is":

=if(not isdate(C10))
<>if(isdate(C10))

Your help would be greatly appreciated!!

 

[lenze]

ISDATE is NOT a worksheet function in Excel, although it does exist in VBA. It also exist in Data Validation. What are you really looking to do?

lenze

 

[Laavista]

I have a report from a supplier that is supposed to have dates. The date field occasionally has a dash or a word like "NotAvailable". In VBA, I check in the VBA whether it's a true date before I do a search on it , but I also want to highlight the cell which does not contain a true date in pink.

I could loop through the rows and check to see if it's a date, and if not, highlight the cell. I'd rather just do a conditional format, though.

Does this make sense?

Thanks for your help!

 

[lenze]

Since dates are really just numbers, you can just use

=NOT(ISNUMBER(A1))

lenze

 

[Laavista]

Actually, that will work!

Thanks so much for taking the time to reply to my question. I really appreciate it!!

 

[Laavista]

Is there something I should be checkmarking to indicate you answered my question? (This is my first post on this forum).