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

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

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