Conditional Formating Furmula
 

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.

Conditional Formating Furmula
 

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.
--
David Biddulph

"jockj215" wrote in message
...
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.

Conditional Formating Furmula
 

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" wrote:

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.

Conditional Formating Furmula
 

Spot on and silly me forgot about data valadation

Thanks


"JLatham" wrote:

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" wrote:

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.