Conditional Formating Furmula

[jockj215]

I have to enter a 14 digit licence number in a field this is a mix of numbers
and leters. can some one please give me a formula that i can use in
conditional formating tol show if there are to few or to many digits. (Using
excel 2003) Thaks in advance.

 

[David Biddulph]

CF/ Formula is/ =LEN(A1)<14
Format as desired for too few

CF/ Formula is/ =LEN(A1)>14
Format as desired for too many

Rather than using CF you could, of course, use Data validation to require
LEN(A1) to be 14.

 

[JLatham]

You can deal with this with conditional formatting or data validation, or both.

Formula for conditional formatting (for cell A1)
=LEN(A1)<>14
and set your format for the not-14-characters condition.

You can also use Data Validation and use 'Text Length', 'exactly' and enter
14 as the length.

 

[jockj215]

Spot on and silly me forgot about data valadation

Thanks