Disable a drop-down list based on Another drop-down ?

[RahulNa]

Hi Friends,

I hope all of you guys are doing well.

The problem I am facing is on multiple drop-down lists with the value "Yes" or "No". I have 4 columns, Business Head, Region Head, Sales/EM, Inside Sales.

Each column has a drop-down of "Yes" or "No". So, I want if the Business head has selected Yes, then the rest of the drop-down should be frozen. In case it's No & Region Head is Yes, then the rest of the others should be frozen.

 

[kanadaaa]

I'm pretty sure we'll need a little more information on what the table looks like to write a code for this one, especially in what row and column the headers are in.
Maybe you can upload an image of your worksheet or an XL2BB sample for us?