Validation

A

ADK

Is there a way to have a cell validate the following parameters:

1. Ignore blanks
2. Date greater than 1/1/07
3. "NR" value is acceptable

So far I can only do 1 & 2
 
D

Dave Peterson

I selected my range and with A1 the activecell, I used:
Allow: Custom
Formula: =or(a1="NR",and(isnumber(a1),a1>date(2007,1,1)))

It seemed to work ok.
 
C

carloss

Is there a way to validate that a cell is all caps and has 25 or less
characters. I can't get it to work.

Thanks
 
Top