Any value validation is a type of validation that utilizes the input message to communicate rules to enter data in a cell. The moment an Any Value validated cell is made active, the Input Message is displayed as a prompt to the user. There are no criteria, data restrictions, or error messages set up with an Any Value validation.

Add a data validation to cell G$6$ with the Input Message only Please enter a time in the following format: HH:MM AM$/$PM$.($Include the period$).$

Add a data validation to cell G$4$ that only allows values from a list with the source data from cells B$26$:B$30$ on the ListData worksheet. The Input Message should have a title Reported By

Add an Input message Choose a name from the list. $($Include the period.$)$

Add an Error Alert Stop title Error

Add an Error message Please choose a name from the list. $($Include the period.$)$