| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I prevent data from being entered into a particular cell? | Excel Discussion (Misc queries) | |||
| MACRO: Catching only filled cell data | Excel Discussion (Misc queries) | |||
| prevent data entry into cell? | Excel Worksheet Functions | |||
| Checking if a cell is filled up with data | Excel Discussion (Misc queries) | |||
| How to prevent cursor from moving behind filled cells | Excel Discussion (Misc queries) | |||
Linear Mode
