Data Validation Techniques in Microsoft Excel

Using Data Validation in Excel

Apply data validation to cells

Add tick/ cross into your Data Validation and use it in IFs and Conditional Formatting

Excel: The Basics of Data Validation and Conditional Formatting

Prevent Errors Using Data Validation

Data Validation: Techniques, Types, and Best Practices

Data Validation: Overview, Types, How to Perform | Built In