Search for courses or lessons
Redeem a coupon
Start free trial
How do you ensure that only dates, in a valid format, can be entered in a particular cell?
Create a data validation rule for the cell that restricts users to only entering dates
Set up a data validation input message for the cell
Put a message in the cell that says users need to enter a valid date
Suppose you want a message to pop up each time a particular cell is selected. How do you make this happen?
Use a comment
Use conditional formatting
Use a data validation input message
What is the most likely cause of this error message shown here?
The user attempted to enter data into a protected worksheet.
A validation rule exists on the cell, but the rule's author didn't configure an error message
A validation rule was configured, and the rule's author programmed the error message text to read as in the message
Back to the top
© 2019 GoSkills Ltd.
Skills for career advancement