There are a couple of sample files with cross dependent validation:

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

Look for 'DV0037 - Dependent Lists Country City' or 'DV0013 - Cross
Dependent Validation Lists'

guz wrote:
Thanks for that, I've already been there!
To explain further using that site as an example
If I change cell A2 from Green Fruit to Red Fruit I would want cell B2 not
to show Lime but the list of red fruits

"Carim" wrote:


Hi,

Take a look at Debra's brilliant site :

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

HTH
Cheers
Carim





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html