Data Sorting

[knghtandyk]

Hi.
I am using excel (200)for logging of unit serial numbers of 16 characters length, containing alpha-numeric characters that are entered via a usb barcode scanner.
Unfortunately the scanners are intermittently adding or removing characters from the data.
I am trying to find out if there is any way to set a worksheet up to highlight a cell in a row if an alpha-numeric serial number greater or less than 16 characters in length is entered.
Any help on this would be very much appreciated.
Thanks!

[knghtandyk]

Sorry, the (200) was supposed to be 2000, meaning i'm using excel 2000.
Thanks again.

[swatsp0p]

Use Conditional Formatting:

Set Condition 1 to:

Formula Is: and enter =LEN(A1)<>16

where A1 is the cell you want to evaluate.

Click Format... and choose the Patterns tab

Select a Fill color and click OK twice to exit.

Copy this cell and Paste Special>Formats to all desired cells

Any cell with more or less characters than 16 will be highlighted in your chosen color.

HTH

Bruce

[knghtandyk]

Thanks alot! I'll give that a try.