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. |
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 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. |
All times are GMT +1. The time now is 07:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com