Post how to disable cells if selecting a value using drop down

J

js1537

New member
Joined
Aug 30, 2014
Messages
3
Reaction score
0
Points
0
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.
 
You could add data validation to B1:G1 with a type of Custom and a formula of =$A$1<>"yes"
 
I think you need to be more specific.
 
You must log in or register to reply here.
Back
Top