Data Validation

[fhermx]

Hello I need some help to find out the best way to validate some date on my sheet. For example I have my customer PO, QTY and Part number. On the next available line the user will input the require information but let say that he/she doesn't have the Customer PO, so he/she will type the QTY but I would like to use a data validation to stop at that point and ask to input first the Customer PO before he/she continue typing the rest of the info. Thanks for your help!!!![TABLE="width: 500"]
<tbody>[TR]
[TD]CUSTOMER PO
[/TD]
[TD]QUANTITY
[/TD]
[TD]PART NUMBER
[/TD]
[/TR]
[TR]
[TD]123ABC
[/TD]
[TD]5000
[/TD]
[TD]85236-85
[/TD]
[/TR]
[TR]
[TD]456DEF
[/TD]
[TD]8000
[/TD]
[TD]85236-99
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[FDibbins]

Based on your sample, go into DV, select CUSTOM from Allow, uncheck IGNORE BLANKS, an dthen enter this in the formula...
=A3<>""