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

C

cyndi

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.
 
M

Max

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

cyndi

Perfect! Thanks so much

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to format cells -fill color 2
Add numbers if cell fill is a certain color; How To? 5
Data Validation - Prevent delete 2
Filling Out Cells Based on Data Validation 1
Data Validation - Preventing Delete from Delete Key 2
how to have cells automatically fill when entering value in ref 1
Copy data from unlocked cells 3
Strip out certain rows that have merged cells 2

Top