You can use ISERROR to test whether a value or the results of a formula are an error. It will return TRUE if it detects an ...
If you've used data validation in Excel before, you probably selected the relevant cells, clicked "Data Validation" in the ...