This video shows how Data Validation criteria can be set up with Excel formulas. For example, we show how to ensure that entering any non-numerical entry in column A creates an error message.
There is only one file for this video. The first file necessary is a blank workbook. The included file is the finished file and is for reference.