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.