Hi guys looking for a bit of help on a method to lock a cells base on another cells contents
Example
If A1 = YES then user cannot enter data into B1
If A1 = any other content a user can etner data into it
do you know if there is a formula method of this?
Help appreciated
Barbara
What if A1 is left blank?
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
If A1 = blank then user can also enter data in to B1
thank you
Try this...
Select cell B1
Goto the Data tab>Data Validation
Allow: Custom
Formula: =A1<>"Yes"
You can include custom input/error alert messages if desired.
Note however, the user can still copy/paste or drag-n-drop into cell B1. The only way to prevent those operations is to use a VBA event macro.
Great Tony Thanks For The Help!
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks