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"?