Hi All,
I am new to the forum and a bit at something I want to do in exce and any help will be much appreciate. What I want to create is 3 drop down (yes and no) for 3 columns, for example, Column, A1, B1 and C1.
If A1 is drop down list is chosen Yes, both column will either disabled or only no option drop down list to choose.
It has to apply to the entire column of A1,B1 and C1 as all the rows will be populated with data.
I attahced the sceenshot of what like to create. If you could help that will be much appreciated.
Best Wishes,
THA
I am new to the forum and a bit at something I want to do in exce and any help will be much appreciate. What I want to create is 3 drop down (yes and no) for 3 columns, for example, Column, A1, B1 and C1.
If A1 is drop down list is chosen Yes, both column will either disabled or only no option drop down list to choose.
It has to apply to the entire column of A1,B1 and C1 as all the rows will be populated with data.
I attahced the sceenshot of what like to create. If you could help that will be much appreciated.
Best Wishes,
THA