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

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.
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
You could add data validation to B1:G1 with a type of Custom and a formula of =$A$1<>"yes"
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
I think you need to be more specific.
 
Top