You could check out Kid Van Ouytsel's superb workbook included with this article:

http://www.markrowlinson.co.uk/xlvalidation.php

on my website. It's probably one of the best resources on Excel's data validation feature that there is.