Hi!

Sounds like you want dependent dropdown lists.

Instructions can be found he

http://contextures.com/xlDataVal02.html

Biff

-----Original Message-----
I want to add validation to a cell based on what is
selected from a drop down
in another cell. eg. If apple is selected excel will
take validation from
one area if orange is selected excel will take validation
from another list.
I hope this is clear.
.