Debra's approach requires static lists behind each
piece of the validation.
Well, not exactly............
I guess you missed the section on creating Dynamic Lists.
Try also
http://www.contextures.on.ca/xlDataVal13.html
or
http://www.contextures.on.ca/xlDataVal15.html
Gord