Validating data extracts
Guidelines for the validation of DNA extraction methods especially in the scope of the analysis of genetically modified sequences in food and feed products by real-time polymerase chain reaction (real-time PCR) are described.
If the two substrings match exactly, the formula returns TRUE and the validation passes; otherwise FALSE is returned and the validation fails.
To limit the entry to a date within a specified range, you can use either the predefined Date rule with the "between" criteria or make a custom validation rule with this generic formula: Please notice that the boundary dates are locked with absolute cell references.
To restrict a user to entering only weekdays or weekends, configure a custom validation rule based on the WEEKDAY function.
In yesterday's tutorial we started to look at Excel Data Validation - what its purpose is, how it works, and how to use built-in rules to validate data in your worksheets.
Today, we are going to take a step further and talk about the nitty-gritty aspects of custom data validation in Excel as well as experiment with a handful of different validation formulas.