I believe you can also select a range of cells (including an entire
column / row) THEN do the select Validation setup from the menu.
Selecting Validation from the menu should bring up a mini-wizard
where you can select the list-range, default cell as well as error
messages should the user violate your guidelines.