we're talking about validation if you have a form that are there people are
entering information you can use data validation to ensure that you get the
right type of answers in your specify areas so for example you have a
dog boarding form and I want here is to have their arrival date to be equal to or
greater than today for what I can do your for starters I'm gonna go up to A1
cell here equals today and opening bracket and closing bracket and that will give us today's date so we are clicking in the cell where we want them to put the date in
so we are going on the data tab here and select data validation let's let the date and we wanted greater than or equal
to and then click this little red arrow on the start date and click on today's date and press enter we'll say ok
if they wanted to enter 01/01/2016 and press enter here it is going to give you an error message so that is how that works
you will definate get a good date in here make sure that they haven't heard anything incorrect let's put less than
or equal and 25 just make sure they have entered something in error
ok so once again let's type 35 just to see the error message that's working perfect so
le's go canceled and now let's enter 5 now the next field is the type of
dog this is a field people might get carried away writing little stories about what type of dog
how happy you were how how good he is and everything else so let's restrict
the type or the amount of text that can be supplied in here so let's go drop this down and
let's go and text length let's go
go less then and I don't think there's a breed with more than 20 characters in
the name of it looks a less than 20 characters long what the response has to be
so let us go type a bunch of K here and press enter and you get you error message one more time so lets type in Lab and it works
so now we have the third use of data validationn so how active is your dog let's give them three choices here
so let's go back to data validation and let's select list
so let's say they can be very active, some what active now each option is separated by a comma and you can put as many as you like in there
so we say Ok on this one and then you notice that you have a drop down list here
so you can select some what active so that is a good use of data validation
Please subscribe