Automatically changing the content of a 2nd (dependent) dropdown selection

Hi everyone,

Hope that someone can help me with the following struggle I have.

I created a worksheet having dropdown selections that depend on the content of another cell.

In the attached example the content of
D1 (which is a dropdown) determines which selection can be made in E1 (also a dropdown)
The same for
F1=> G1 and
H1 => I1

I have a few questions.

There is also an option ' - ' in the dropdown selections of D1, F1 and H1.
What can I do to automatically change the content of the corresponding cell to ' - ' also?
e.g. if D1 is changed into ' - ' I would like that E1 automatically changes to ' - '.
See e.g. Cell I1 which contains "A method" although H1 = ' - '.

In addition, is it possible to somehow indicate that if the content of D1 is changed the actual value in E1 should also be changed (ideally by activating the right drop down selection), but a color warning would also be nice.
So if I change the content from D1 being a "Method general" while E1 is showing/selected "A calibration method", how to flag that E1 should change when the content of D1 changed?

Last question .
In Cell A1 I included a "check box"
Is it possible to show/activate the content of cells D1:I1 when the check box is checked and to make cells D1:I1 empty when this checkbox is unchecked?
If possible, I want to use multiple check boxes for different types of content, but having a solution for these issues would already be great.

Hope the questions are clear. Any help and suggestions are highly appreciated!


Best regards, Jan