Data Validation

[LAF]

I have a range in my Excel spreadsheet where the user can enter data. This range is V23:S28. For each row, I want to stop them from entering data in the corresponding row for this range when a required field in column B has not been entered. For example, if a user enters a value in V23 and cell B23 is blank, then I want to issue a warning message and not allow the data to be entered. Is there a way to do this using data validation?

[Debra Dalgleish]

Select cells S23:V28
Choose Data>Validation
From the Allow dropdown, choose Custom
In the formula box type: =$B23<>""
Remove the check mark from Ignore blank
You can add an Input message, or Error Alert
Click OK


LAF wrote:
> I have a range in my Excel spreadsheet where the user can enter data.
> This range is V23:S28. For each row, I want to stop them from entering
> data in the corresponding row for this range when a required field in
> column B has not been entered. For example, if a user enters a value
> in V23 and cell B23 is blank, then I want to issue a warning message
> and not allow the data to be entered. Is there a way to do this using
> data validation?
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html