Qaspec,

Chris Marlow is correct in his suggestion. But, incase it is difficult to understand without examples, check this out--a step by
step tutorial on dependent validation lists. I found it very valuable and easy to understand:

http://www.contextures.com/xlDataVal02.html

I hope this helps,

Conan


"Qaspec" wrote in message ...
Sorry typo
I would like the validation
in column d to run from a list in column x, y or z respectively.

"Qaspec" wrote:

I have validation set in column c that runs from a list in column w.
Depending on the value chosen red,blue, or green, I would like the validation
in column c to run from a list in column x, y or z respectively.