Originally posted by csamuels
specify allow list, create a list of valid entries in your spreadsheet, then in settings assign the list you just created. goto error alert to specify an error message when invalid input is entered.
this will also create a drop down list for your users to choose from.
Thanks very much for taking your time out in helping me out here & is much appreciated.
This was simply a stellar. It did the job, exactly the way I wanted & can apply it on my spreadsheet, however, this time, I simply will have to add additional column for the "list" & then can hide the column, so whoever types it won't be able to see what the input is meant to be, unless he/she knows it beforehand.
This was my very first post on this website, which I came across while browsing the net & as THEY say, a satisfied customer always comes back. So, I'll be around on this forums, from now onwards.