I have a Google Sheets spreadsheet with a date column. A contributor to this spreadsheet keeps entering dates in invalid format. I would like to conditionally format the cells in this column to have a red background if the text cannot be interpreted to be a valid date.

How can I do this?


1 Answer 1


It is possible to do this by using a custom formula in the conditional formatting. Assuming that you are conditional formatting the cells A1:A, enter this conditional formula:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.