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!
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
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