| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation-Only allow entry into cell if adjacent cell is fil
I have cells that are slotted for $ amounts, however, I only want entry to be
allowed into these cells if the preceding adjacent cell has been filled. If the preceding cell is blank, the $ amount cell should not be allowed to be filled. How can I do this? -- KKD |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Validation-Only allow entry into cell if adjacent cell is fil
Say you want A2 to be disallowed entry until A1 is filled.
In xl2003 menus: Select A2 Data|validation|Settings tab| Allow: Custom Formula: =A1<"" And make sure you uncheck that "ignore blank" checkbox. That's very important. But this kind of thing won't stop anyone from putting something in A1, then A2 and clearing A1. Are you sure it's worth the trouble? KKD wrote: I have cells that are slotted for $ amounts, however, I only want entry to be allowed into these cells if the preceding adjacent cell has been filled. If the preceding cell is blank, the $ amount cell should not be allowed to be filled. How can I do this? -- KKD -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Validation-Only allow entry into cell if adjacent cell is
I see what you mean...well this should eliminate the ignorant mistakes at
least...as for the purposeful ones...hmmm -- KKD "Dave Peterson" wrote: Say you want A2 to be disallowed entry until A1 is filled. In xl2003 menus: Select A2 Data|validation|Settings tab| Allow: Custom Formula: =A1<"" And make sure you uncheck that "ignore blank" checkbox. That's very important. But this kind of thing won't stop anyone from putting something in A1, then A2 and clearing A1. Are you sure it's worth the trouble? KKD wrote: I have cells that are slotted for $ amounts, however, I only want entry to be allowed into these cells if the preceding adjacent cell has been filled. If the preceding cell is blank, the $ amount cell should not be allowed to be filled. How can I do this? -- KKD -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting a cell entry based on cell validation selection | Excel Worksheet Functions | |||
| Sum of cells based on entry of adjacent cell | Excel Worksheet Functions | |||
| Validation List to fill adjacent cell with IF? | Excel Discussion (Misc queries) | |||
| How do I set up Auotomatic date and time entry in an adjacent cell | Excel Discussion (Misc queries) | |||
| Data Validation / Cell Entry | Excel Discussion (Misc queries) | |||
Hybrid Mode
