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,
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,