Validation

[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

 

[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.

 

[Guest]

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

 

[Dave Peterson]

Check your other post.

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