Validation Feature

  • Thread starter Validation Feature
  • Start date
V

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

Bernie Deitrick

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
 
Top