Say you're hosting a party, you've invited your friends, and want them to fill out a spreadsheet to indicate the best way to contact them, how many guests they're planning to bring, and what flavor of ice cream they prefer to eat.
First, select a range of cells and use Tools > Data Validation to set up the rules. You can set up a rule to make sure that only valid email addresses are allowed so you know the best way to contact your friends.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi4EmjEuCXm6a3ZRW93OMsHl1VQuKWe9x809l5EoOuPTh-CE-6fmO8JGAZto-vhJzrtz1lEfrtyIoFDp2pwUXTA9rqQKmbLqgQDr9hL0qSWw2vJnZErz19iefK27T2pBYi-jOFOJ1CjqS5U/s400/Picture+81.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQF_4VuqxbkQcwtBUp_J5H7M-6wu_-4NIVT-xQaE6I7pkeofArXNt_BCL3aeesGHtF5m9Yr_75BF54JUReEi62uHxXB3gbQnfidViDzWRRYS_zcqT1pFVN7Ov8U2rp4kfM_knG0WDzKxi5/s400/Picture+82.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTUz_379xsjhvSnJuGE8VdMQ1fiQCTkK2eDh_WJb9OOBQTAovxXQOov6004uW5x0AGSrS-GzHmI6CL9oQTHmvoUBhyphenhyphenDNr3LoFYy5W2lg4mpcLyv5n_Hc59Y4kNjkw6AhTBc3kwRO12KWkW/s400/Picture+83.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhn16hTNVNit4Wk-ZoAk1faZTcJ5ERmegK7zsfYJQGJgKmCob4R6yl0QzQtCzUl3eREM6QWMEWHCa8PBkK6n3A9SIW9BKLZ_geB9VCaUYRKPSneazkzCBHTWOZKGKd_IDtaewyhcRaHWY5y/s400/Picture+84.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOL-PvJYDS4PD4ra1Z6W3aFBD8VICvYWpITo-IKtS0F4pFnTvSiK780yx_gtCO8fq1kLNKEvRLKT4tkKsjairvCPMUdbwCWDuhkvFQvZj96Z0eSj8zI9eHGrZj1cG7HUUKEBxkCdLXFGOZ/s400/Picture+85.png)
For this rule, your friends will see an ice cream flavor suggestion but they'll still be allowed to enter different flavors.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPZxHLoO-8qsDPrGfv12AhaQvTAJWbslBVGCH3QM9s62S-arwWHEzbX9WvU3z2PSQXYYBaY24gy51xaLds8UNqpCF7ulakptdiY5Zwukzo0XnXR0kZarCdCp3Y520PJrZx9KTDaBiu6AY1/s400/Picture+86.png)
A few notes on this new feature:
- If data validation is applied to cells containing data, rules won't be applied until the data is modified.
- Only one validation rule can be applied to each cell.
0 comments:
Post a Comment