Conditional Formating Furmula

  • Thread starter Thread starter jockj215
  • Start date Start date
J

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