Hello Friends -
Is there a way to have a set of data validations drop-downs that update accordingly based on the selection from any other drop-down?
For example, by selecting "Hot" from any drop-down from the set of 3 below, is there a way for the remaining Data Validation drop-downs to also update to "Hot" and the output in cell D9?
Is there a way to have a set of data validations drop-downs that update accordingly based on the selection from any other drop-down?
For example, by selecting "Hot" from any drop-down from the set of 3 below, is there a way for the remaining Data Validation drop-downs to also update to "Hot" and the output in cell D9?
Book1.xlsx | ||||||||
---|---|---|---|---|---|---|---|---|
C | D | E | F | G | H | |||
6 | ||||||||
7 | ||||||||
8 | Output | Data Validation 1 | ||||||
9 | Hot | Hot | ||||||
10 | ||||||||
11 | ||||||||
12 | ||||||||
13 | Data Validation 2 | |||||||
14 | Hot | |||||||
15 | ||||||||
16 | ||||||||
17 | ||||||||
18 | Data Validation 3 | |||||||
19 | Hot | |||||||
20 | ||||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D9 | D9 | =G9 |
Cells with Data Validation | ||
---|---|---|
Cell | Allow | Criteria |
G9 | List | Hot, Warm, Cold |
G14 | List | Hot, Warm, Cold |
G19 | List | Hot, Warm, Cold |