Hi,

I would like to know if it's possible to change a cell in excel from a list to ranged cell, depending on another cell.
For example, in case cell A1 have a value "X" then Cell B1 will be from type list.
in case cell A1 have a value "Y" then Cell B1 will be from type ranged cell.

Is this possible to do on excel 2010 ?

Thanks !