prevent a cell from having data add with out another celled filled

[Guest]

Hello, I am using Excel 2003, I have two cells that require information, one
is the "item number" and the other one is "quanity" I don't want to be able
to add anything to the quanity cell until the "item number" cell is filled
out. Is there a way to prevent this, I looked in validations and wasn't sure
if any of the choose would work.

Thank you in advance.

 

[Guest]

Suppose the item no. cells are in B2 down, qty cells in D2 down
Select the range D220 (say),
Click Data > Validation
Allow: Custom
Formula: =B2<>""
Uncheck "Ignore blank"
Click OK

 

[Guest]

Perfect! Thanks so much

Suppose the item no. cells are in B2 down, qty cells in D2 down
Select the range D220 (say),
Click Data > Validation
Allow: Custom
Formula: =B2<>""
Uncheck "Ignore blank"
Click OK

 

[Max]

welcome, cyndi.