Allowing data entry into cell only if another cell has a value

  • Thread starter Thread starter NeedHelp
  • Start date Start date
N

NeedHelp

Is there a solution to only allowing the user to enter
data into a cell only if another cell has been completed.
More specifically, I have two categories: date sent and
date recieved - obviously a date received can only be
entered IF a value exists in date sent.
 
Hi
if the first cell is A1 and the second one A2, enter the
following custom validation formula for cell A2:
 
You can use data validation --

Select the Date Received cells
(cell D2 is the active cell in this example)
Choose Data>Validation
From the Allow dropdown, choose Custom
In the Formula box, type a formula that refers to the
Date Sent cell in the active row (C2 in this example)
=AND(C2<>"",C2<D2)
This formula checks that C2 isn't empty, and is less
than the value entered in D2
Click OK

Note that data validation isn't foolproof -- users can paste invalid
data into the cell.
 
Back
Top