I have a .xlsx file that is being used as a template for surveyors to fill in. Hence it's NOT a macro enabled file.
I want the surveyor's to enter a date in cell G4 (which is formatted as a date, dd/mm/yyyy). How do I use conditional formatting so that if the surveyor does not enter a valid...