Beyond Conditional Formatting...

[Guest]

Is it possible to have the content of one cell in a row dictate the content
of the following cells? For instance, if you chose answer A from a dropdown
in the first cell, could you display one set of dropdowns in the other cells
in that row, and then display another set of dropdowns if you chose answer B?

 

[Peo Sjoblom]

Maybe something like this

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



--

Regards,

Peo Sjoblom

Is it possible to have the content of one cell in a row dictate the content
of the following cells? For instance, if you chose answer A from a dropdown
in the first cell, could you display one set of dropdowns in the other cells
in that row, and then display another set of dropdowns if you chose answer

B?