L
Larsb001
I am creating a model where a user can select a parameter in cell A1, in this
case either "Secure existing business" or "New business".
Dependant on the answer in A1 the user should enter a number in either cell
B1 (secure business) or C1 (new business), i.e. a revenue number where the
value 0 have been pre-entered.
Is it posible to get the two input cells formatted in a way so B1 is blanked
out and appears as a non input cell when "New Business" is selected (only C1
would appear as a input cell) and opposite.
Hiding columns is not an option. Have tried conditional formatting and any
other functions I cound think of, without any success.
Sorry if this have been covered before but can anybody help here?
Regards, Lars
case either "Secure existing business" or "New business".
Dependant on the answer in A1 the user should enter a number in either cell
B1 (secure business) or C1 (new business), i.e. a revenue number where the
value 0 have been pre-entered.
Is it posible to get the two input cells formatted in a way so B1 is blanked
out and appears as a non input cell when "New Business" is selected (only C1
would appear as a input cell) and opposite.
Hiding columns is not an option. Have tried conditional formatting and any
other functions I cound think of, without any success.
Sorry if this have been covered before but can anybody help here?
Regards, Lars