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.





For this rule, your friends will see an ice cream flavor suggestion but they'll still be allowed to enter different flavors.

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