Create the little dropdown give the users the exact values for them to pick from. Another type that I want to show up here is arrange a numeric range.
I want to specify that within a column in this case within the Rate column.
You can only put values 14.95 and 39.95. You put something less than 14.95 or something more than 29.95 and you’re going to get an error one allowed to happen.
First step, when we created the list for make. You’ve got to select the cells that you want to apply the validation to. I select I4 to I30
Then go to Data tab back into Data validation, data validation. on the Settings tab, we’re not going to allow any value. Again I want to specify that range.
Go to the dropdown, we’ve got a number of different validation criteria here.
We’ve got Whole numbers where you can specify a range and has to be between 1 and 10, something like that you’ve got decimals which is what we’re about to use here.
You can only do between 14.95 and 39.95 in the RATE column you got list that we saw.
A range of values for the length of the value you can do that with this option here.
The last option custom allows you to create calculations that define the criteria for you.
For this option again this is the Rates it’s got a decimal. So I’m going to go ahead grab the Decimal operate operator and then I’ve got the data where the crane operator is set to between what I do have a handful of other options to pick from.
Hit OK and now you’re not going to get a dropdown like we got in the list option.
If the user jumps into this column anywhere between eye for an eye 30 they drop in a value, it’s going to get validated.
This value does not match the data validation restrictions defined in this list.
I put something in at I20 like 44.95. That’s outside of our range our maximum was 29.95.
I hit Enter key and I’ve now got a nice little error. This value does not match the data validation restrictions defined in this list.
That’s a nice error but perhaps it’s not the most user friendly prompt and message to the user.