Hi,
I have two values (Yes and No) in a drop down in A1. If i select yes then only cells (B1 to G1) should be disbaled. i.e. no one can select cells (B1 to G1) or make non editable cells. If i select No then these cells (B1 to G1) should be editable or selectable.
I have two values (Yes and No) in a drop down in A1. If i select yes then only cells (B1 to G1) should be disbaled. i.e. no one can select cells (B1 to G1) or make non editable cells. If i select No then these cells (B1 to G1) should be editable or selectable.