Data Validation
 

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

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

I did not receive your answer yesterday. I apologize for that. I do have a
data validation list in c3 which allows Active or Inactive
Do I put the formula in custom data validation? What does undec mean?

"Peo Sjoblom" wrote:

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

Sorry, undec should have been under, just use datavalidationallowcustom
and in the formula bar put

=C3="active"


if that does not work you can use

=OFFSET(D3,,-1)="active"


--

Regards,

Peo Sjoblom


"JJalomo" wrote in message
...
I did not receive your answer yesterday. I apologize for that. I do have
a
data validation list in c3 which allows Active or Inactive
Do I put the formula in custom data validation? What does undec mean?

"Peo Sjoblom" wrote:

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

Thank you. That works, except I also need to populate a Zero if the user
selects Inactive in C3
What would I have to modify

"JJalomo" wrote:

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