Conditional

  • Thread starter Thread starter Juran
  • Start date Start date
J

Juran

I need to enter/scanning a series of serial number, but I
want to use a conditional or any other commend that tells
me that I enter the wrong serial number.

Ex.:

S/N TDI1132490
S/N JM5243850

I was trying to use contidional were if the S/N was TDI*
will the serial numbe and if it was diferent will write Error

Any Suggestion?

Thank you.

Juran
 
You can use command: Data|Validation|Settings and in Allow combo box
select "List". Then select valid entries you allow to be in the cell.
HTH
Billy
 
Billy:
How do you write the equivalent of "Three valid letters plus any
combination of seven digits" into your list?
 
For that type of validation you have to write all valid entries in the
worksheet cells. For example in block from A2:A10 and then for list you
show/point on that block. So then you can type or select from drowdown
combo box only values in that block you select.
 
Back
Top