Enforce data entry prerequisite

[wpryan]

Hi All,
I have a form where some data entry is expected, but prior to entering the data, a person must complete a prerequisite cell. In this case, I'd like it so if cell D50 is blank, then cells in range C10:C46 are locked. How is this possible?

 

[Z51]

Select C10:C46, then click Data > Data Validation
On Settings tab, select Allow > Custom
Beneath Formula, type: =$D$50<>""
Un-check the box next to "Ignore blank"
On the Error Alert tab, 'Show error alert....' should be checked, Style > Stop, and if you want a custom error message add that under Title & Error Message sections, e.g. "You must enter a value in cell D50 before entering data in C10:C46."
Click OK

 

[wpryan]

Select C10:C46, then click Data > Data Validation
On Settings tab, select Allow > Custom
Beneath Formula, type: =$D$50<>""
Un-check the box next to "Ignore blank"
On the Error Alert tab, 'Show error alert....' should be checked, Style > Stop, and if you want a custom error message add that under Title & Error Message sections, e.g. "You must enter a value in cell D50 before entering data in C10:C46."
Click OK

Thanks for the answer. The dialog box that comes up after the equation is False, gives the option to continue (Yes, No, Cancel or Help). If I hit Yes, I can enter the a value anyway without error...

 

[wpryan]

Thanks for the answer. The dialog box that comes up after the equation is False, gives the option to continue (Yes, No, Cancel or Help). If I hit Yes, I can enter the a value anyway without error...

Sorry, my bad... I reset the warning to "information" instead of "stop". Thanks for your correct answer...