Conditional cell values and inputs

  • Thread starter Thread starter I_need_help
  • Start date Start date
I

I_need_help

Does anyone know if it is possible to make the input conditions of a
cell dependent on the value/formula of/in another cell WITHOUT using
VBA?

example:

if (cell_a = pre_defined_value_a OR
some_condition/formula_is_true) then (cell_b = pre_defined_value_b OR
some_condition/formula) otherwise (user_can_enter_a_value OR
user_can_choose_from_drop_down_list)

Thanks.
 
I_need_help,
You could use an if statement for the first requirement, and Data>Validation for the second.

Good Luck,
Mark Graesser
(e-mail address removed)

----- I_need_help > wrote: -----

Does anyone know if it is possible to make the input conditions of a
cell dependent on the value/formula of/in another cell WITHOUT using
VBA?

example:

if (cell_a = pre_defined_value_a OR
some_condition/formula_is_true) then (cell_b = pre_defined_value_b OR
some_condition/formula) otherwise (user_can_enter_a_value OR
user_can_choose_from_drop_down_list)

Thanks.
 
That's very helpful indeed - thanks.

But can you set multiple data validation conditions for the same cell?


Also, can you make a cell display a value defined in the validation
statement without the user having to click on the cell/mouse?

For example:

if (cell_a = value_a) then (set cell_b to value_b such that value_b is
displayed in the cell without any user involvement) otherwise (allow
some other input into cell_b, e.g. user selects from a drop down list)

Again all without using VB please. Thanks.
 
The best I could come up with is to restrict the validation selection list based on the other cell. I don't see a way to have the B show up automatically when A is entered

1) A1 is where the A would be entered

2) B1 is the cell with validatio

3) E1 is a formula to select the list
=IF(A1="A","A_list","not_A_list"

4) Define cell F2 as "A_list" and enter B in that cel

5) Define range G2:G9 as "not_A_list" and fill in the cell

6) Select B1 and Data>Validatio
Allow: Lis
Source: =INDIRECT($E$1

Now the list of available selection will be limited based on the input of A1. If require an entry in B1 before continuing, you could set up a validation on the next cell to be entered that requires B1 to have an entry

Good Luck
Mark Graesse
(e-mail address removed)
----- I_need_help > wrote: ----

That's very helpful indeed - thanks.

But can you set multiple data validation conditions for the same cell


Also, can you make a cell display a value defined in the validatio
statement without the user having to click on the cell/mouse

For example

if (cell_a = value_a) then (set cell_b to value_b such that value_b i
displayed in the cell without any user involvement) otherwise (allo
some other input into cell_b, e.g. user selects from a drop down list

Again all without using VB please. Thanks
 
Back
Top