Design a formula in XL that evaluates to TRUE/FALSE for
correct/incorrect ID's

Use Data->validation and use option Formula. and use the created
formula to evaluate ID's on cell data entry.

Dm Unseen