Explanation
Data validation rules are triggered when a user adds or changes a cell value.
The ISTEXT function returns TRUE when a value is text and FALSE if not.
As a result, all text input will pass validation, but numbers and formulas will fail validation.
