Reputation: 99
I have a two-column table but I want all values in the first table to be either X or Y, and no other input should be allowed. How can I enforce this?
Upvotes: 0
Views: 293
Reputation: 6826
You can use a validation rule.
Restrict data input by using a validation rule
A Validation Rule on the column as follows will work.
="X" Or ="Y"
Upvotes: 2