Data Validation

J

JJalomo

How do I allow input into a cell only if it meets the criteria of another
cell.

If cell c3 contains "Active", allow input into D3
If cell c3 contains "Inactive" do not allow input into D3
 
D

Dave Peterson

How about:

=(C3="active")

And uncheck that "ignore blank" checkbox on the Data|validation|settings tab.

This actually just verifies that "active" ins in C3. Anything else won't work.

But if you have Active in C3, then type something in D3, then change C3, it
won't have any effect on D3.
 
Top