PDA

View Full Version : Change cell rule from list to ranged cell automatically



momo156
12-12-2011, 07:22 AM
Hi,

Is it possible to change a cell rule from list to ranged cell (and vice versa), depending on another cell value?

For example, in case that in cell A1 there's value "X" then cell B1
is from type list.
in case that in cell A1 there's value "Y" then cell B1 is from type ranged cell.


Thanks,

Aflatoon
12-12-2011, 07:34 AM
Can you perhaps explain what precisely you mean by "type ranged cell"?

Bob Phillips
12-12-2011, 07:39 AM
I presume that you are referring to Data Validation, so you could use a type of List with a formula something like

=IF($A$1="x",M1:M5,$A$2)

momo156
12-14-2011, 01:28 AM
Thanks for your answers.
I Meant that I have cell#1 that its type is a list or a regular cell, depends on cell#2 value.

Aflatoon
12-14-2011, 01:39 AM
So does xld's answer solve your problem?