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?