You can choose from three types of error alerts: Warn users that the data they entered is invalid, without preventing them from entering it.You can use data validation to restrict the type of data or the values that users enter into a cell.Previously part of ABB Consulting, the CSV Compliance team supply spreadsheet validation and compliance services worldwide.You can use data validation to restrict the type of data or values that users enter into cells.
You can also show an Error Alert that appears only after users enter invalid data.
Note: The following examples use the Custom option where you write formulas to set your conditions.
You don't need to worry about whatever the Data box shows, as that's disabled with the Custom option.
One of the most common data validation uses is to create a drop-down list.
Check out this video for a quick data validation overview.