View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cyndi cyndi is offline
external usenet poster
 
Posts: 30
Default 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.