Find and Highlight Invalid Dates

[Makat]

I have a spreadsheet with a large amount of data that I have pulled from another program. One of the columns has dates in it and is producing an error in the other program because some of them are not entered correctly.

Is there any way to search the column in Excel and highlight the cell (or bring attention to that row in any way) if any of the dates are incorrect so I will know which records in the original application need to be fixed?

Thanks,
Makat in FL

 

[delaneyjm]

Take a look at Conditional Formatting. This will allow you to format cells that do not have a valid date in them.

For this case, I would use a formula to drive the conditional formatting. I would use the formula =NOT(ISNUMBER(your_range))

 

[Makat]

Thanks!