Validation Feature
 

I'm trying to use the validation feature, is it possible to set it up so it
will allow for text strings of 9 and the word "Pending"?

Validation Feature
 

Use the custom setting, with the formula

=OR(LEN(A1)=9,A1="Pending")

Select all your cells, and then substitute the Upper-Left cell Address for the A1 in this formula
when entering it in the validation dialog.

HTH,
Bernie
MS Excel MVP


"Validation Feature" <Validation wrote in message
...
I'm trying to use the validation feature, is it possible to set it up so it
will allow for text strings of 9 and the word "Pending"?