I have a cell with a validation list with 2 options. When option 1 is
selected I want Combo_box A to be visible and Combo_box B to be hidden and
vice versa when option 2 is selected.

How can I do this please?