You asked the same thing yesterday and I asked what if someone type
something else
because your question leaves things unanswered. What if someone typed in
"abcde" in
C3, can you enter anything in D3? If not then your criteria should be only
based on "active"
and everything else is not allowed. Or you can have validation on C3 and
using list and put in
Active,Inactive
theat way they can only choose from that

Anyway use

=C3="active"

undec allowcustom

--

Regards,

Peo Sjoblom


"JJalomo" wrote in message
...
How do I allow input into a cell only if it meets the criteria of another
cell.

If cell c3 contains "Active", allow any value to be input into D3
If cell c3 contains "Inactive" do not allow input into D3