formula if cell content doen not equal certain amount of characters

[Marijke]

I need a VBA formula or code that will help me point out some false serial numbers on our reports.
How can I have excel point out when a cell does not equal (let say) 10 characters?
So if a cell contains 9 characters, or 11, it should mark that specifc cellin red fill color.

I've found a lot on conditional formatting, but this is mostly linked to the value of a cell and not it's content....
Can anyone help?

[JOHN H. DAVIS]

This would check Column A for 10 character cells.

Please Login or Register  to view this content.

[Marijke]

Thank you John, this works like a charm!!
(I knew it had to be something this simple....)

[AlKey]

Actually this can be easily accomplished by using formula Conditional Formatting feature. In Conditional Formatting select "Use formula to determine which cells to format" and enter formula =LEN(A2)<>10 than chose the format to apply.

[martindwilson]

that should probably be =LEN(A2)<>10

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.