Forum home » Delegate support and help forum » Microsoft Excel Training and help » Restrict cell entry in 'Cell-B' based on value entered in 'Cell-
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Restrict cell entry in 'Cell-B' based on value entered in 'Cell-
Resolved · Urgent Priority · Version 2003
Reply Fri 1 May 2009, 09:53Delegate Francis said...
Francis has attended:
Excel Advanced course
Restrict cell entry in 'Cell-B' based on value entered in 'Cell-
Hi
How do I do the following:
1. Upon entering '0' in Cell-A, I would like Cell-B to be blocked (inaccessible) from modification with an error message saying 'Not Granted!'
2. Upon entering '1' or '3' in Cell-A, I would like Cell-B to be open for value entry
Thanks a lot!
For upcoming training course dates see: Pricing & availability
RE: Restrict cell entry in 'Cell-B' based on value entered in 'C
Hi Francis. You need to use the Data-Validation tool to do this, although that may limit you to one criteria of data entry. In cell B1 select Data-Validation, Allow: "Custom" and enter "=RC[-1]=1" in the formula dropdown. This will permit editing of cell B1 unless there is a 0 in cell A1.
Two criteria for data entry into a cell may be possible if you tease them apart and send a separate value to another cell and run the data validation tool on that, but really a simple macro might be the best way forward.
Hope this helps,
Anthony
Reply Fri 1 May 2009, 12:25Delegate Francis said...
RE: Restrict cell entry in 'Cell-B' based on value entered in 'C
hhmmm.....the formula is actually rejecting all entries to Cell-A
NB: Cell-A is actually 'D7' and Cell-B is actually 'G7'
RE: Restrict cell entry in 'Cell-B' based on value entered in 'C
Hi Francis. My formula includes a relative reference which you'll need to modify if the cells aren't adjacent. For this sort of criteria selection have you tried a macro?
Anthony
Mon 11 May 2009: Automatically marked as resolved.
|