Hi..

I have a dropdown in column A(with values Yes and No)

If i choose Yes(Say cell A2) from the dropdown,all the cells of the corresponding row(B2,C2,D2,E2,F2....) should be enabled..This is the default way excel works.

My requirement is ..

If i choose No(Say cell A3) from the dropdown,certain cells of the corresponding row have to be disabled(Say C3,E3 and J3)

Please help me over this.

Thanks in advance..