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?


--
LAF
------------------------------------------------------------------------
LAF's Profile: http://www.excelforum.com/member.php...fo&userid=9656
View this thread: http://www.excelforum.com/showthread...hreadid=467970

Select cells S23:V28
Choose DataValidation
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