Conditional

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
 
B

Billy

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
 
H

Herbert Seidenberg

Billy:
How do you write the equivalent of "Three valid letters plus any
combination of seven digits" into your list?
 
B

Billy

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