Is there a way, using custom cell validation, to check for the results
of two other cells and then determine if it will allow text or numbers
into the field?

Example

A B C D
1 4
2
3 5

In Cell c3 allow text entries only if c1<a3 but if c1=a3 then allow
numbers only.

I tried the first part of it like: =IF(C1<A3,TRUE,FALSE)
this only lets it enter any into it if the conditions are true. I am
trying to get it to differentiate the type of data entered though. I
know this can be done with VBA, but I am trying to avoid that because
of macro restrictions on our systems.


Thanks for any help you can provide.

This is one way:

=OR(AND(C1<A3,ISTEXT(C3)),AND(C1=A3,ISNUMBER(C3)) )

(Custom|formula stuff)

Random wrote:

Is there a way, using custom cell validation, to check for the results
of two other cells and then determine if it will allow text or numbers
into the field?

Example

A B C D
1 4
2
3 5

In Cell c3 allow text entries only if c1<a3 but if c1=a3 then allow
numbers only.

I tried the first part of it like: =IF(C1<A3,TRUE,FALSE)
this only lets it enter any into it if the conditions are true. I am
trying to get it to differentiate the type of data entered though. I
know this can be done with VBA, but I am trying to avoid that because
of macro restrictions on our systems.

Thanks for any help you can provide.

--

Dave Peterson

Debra Dalgleish gave a nicer solution in .worksheet.functions.

Dave Peterson wrote:

This is one way:

=OR(AND(C1<A3,ISTEXT(C3)),AND(C1=A3,ISNUMBER(C3)) )

(Custom|formula stuff)

Random wrote:

Is there a way, using custom cell validation, to check for the results
of two other cells and then determine if it will allow text or numbers
into the field?

Example

A B C D
1 4
2
3 5

In Cell c3 allow text entries only if c1<a3 but if c1=a3 then allow
numbers only.

I tried the first part of it like: =IF(C1<A3,TRUE,FALSE)
this only lets it enter any into it if the conditions are true. I am
trying to get it to differentiate the type of data entered though. I
know this can be done with VBA, but I am trying to avoid that because
of macro restrictions on our systems.

Thanks for any help you can provide.

--

Dave Peterson


--

Dave Peterson