Once the settings for your Data Validation have been set, you are able to set any input messages and/or error alerts.
List Data Validation
The List Data Validation is useful when there are only a few valid inputs and the cell is used as a reference. In our project, we used the List Data Validation in our inputs section for many cells. We used some of them to signify either a "Yes" or "No" answer, and others as specific percentages. The following pictures show these two types of lists.
Subscribe to:
Posts (Atom)