Restrict cell entry in 'Cell-B' based on value entered in 'Cell-

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