Is it possible to only lock a cell if a certain cell is yes?
For example I only want to be able to edit cell A1 in case cell A2 is "yes"
In case of no I want cell A1 to be locked.
I know how to lock a cell but I do not know how to combine it with an if situation.
Hope somebody can help me!
Thanks!
Last edited by keis386; 06-18-2015 at 10:18 AM.
You can use Data Validation for this. On cell A1 open the DATA > VALIDATION and use the settings:
Allow: Custom
Source: =A2="Yes"
On the ALERT TAB you can set a helpful message.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks! Is it also possible to only insert numbers?
Seems you want Source: =AND(ISNUMBER(A1),A2="No")
Actually:
=AND(ISNUMBER(A1),A2="Yes")
Yeah, that!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks