View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
janw janw is offline
external usenet poster
 
Posts: 7
Default Can I include a "validation drop down" in a conditional statement?

I'm using Excel 2003 and trying to set up a situation where an "If" statement
would allow me to place a "validation drop down list" in the cell if the
conditions of the if statement return a logical "true".

That is, if I'm in cell B2, and my conditional is "=if(A20,XYZ,0), and cell
A2 equals 1, I want to substitute a validation drop down for XYZ in the
statement.

Does anyone know if this is possible?

Thanks,