validation

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.

check Data Validation: Take it to the next level

Ray

Check out Debra Dalgleish's site for creating dependent lists.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben Excel MVP

On Tue, 1 Mar 2005 21:13:02 -0800, Ray <[email protected]> wrote:

>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.