Turn Conditional Formatting and Data Validation On and Off with a Checkbox Data validation can make it far less likely
that a user accidentally will enter incorrect data. Sometimes, however, you might need to make it
easier to enter data that otherwise would be flagged as incorrect by
conditional formatting or blocked completely by the
validator [Discuss (1) | Link to this hack]
This hack goes into detail on how to trigger conditional formatting using the checkbox, but doesn't describe how to use the checkbox for data validation except to say you can apply the same principle. Unfortunately, the process isn't at all intuitive and greater detail would be appreciated.
