Mandatory Input based on another cell

I'm aware of validation to PREVENT entry to cells without prior conditions, but my requirements are the opposite of this.

If there is data in a specific location on a SPECIFIC worksheet, REQUIRE input in another cell on that sheet.

I've played with code to accomplish this across a workbook, which as I understand it is the only way this can work, but, I need this for only specific worksheets in a workbook. Here's the code I used via a workbook scope. Can this be applied to a worksheet scope?

Please Login or Register  to view this content.

I figured this out by putting boolean values to check for input in one location, and basing my data validation off of those boolean values.

For example, I have the formulas: =IF(A268="",1,0) in Cell L2 (Require something in cell A268), and formula =IF(B2="",1,0) in cell K2 (Require something in cell B2). So, I select where I want input validation, and for the criteria, I selected "Custom" from the drop down. I used the formula "=AND($L$2<>1,$K$2<>1)" for the criteria. So, if cell A268 or B2 are empty, prevent entry into my selected area for data validation (prevent data from being entered).

I probably could have just put the formula in the data validation for the cells directly, rather than using helper cells.