View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How do I do conditional validation in excel?

See Debra Dalgleish's site for some instructions:
http://contextures.com/xlDataVal02.html

Barry wrote:

I want to set up a cell with conditional validation. If an answer is (x) then
validation comes from d:2 if answer is (y) then validation comes from d:3.
Can excel do this?


--

Dave Peterson