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

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.

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

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"cyndi" wrote:
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.

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

Perfect! Thanks so much

"Max" wrote:

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"cyndi" wrote:
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.

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

welcome, cyndi.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"cyndi" wrote in message
...
Perfect! Thanks so much