Custom Cell Validation

  • Thread starter Thread starter Random
  • Start date Start date
R

Random

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)
 
Back
Top