Question: You want to create a validation rule to prevent the user from accidentally entering a negative value. For now, you will create a validation in
You want to create a validation rule to prevent the user from accidentally entering a negative value. For now, you will create a validation in the Friday worksheet.
Select the range E:E in the Friday worksheet, create a validation rule to allow a decimal value greater than or equal to zero. Enter the input message title Tip and the input message Enter the amount of tip. including the period Use the Stop alert with the error alert title Invalid Number and the error alert message The tip must be zero or more. including the period Test the data validation by attempting to enter in cell E and then cancel the change.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
