| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to get a furmula for get a percentage | Excel Worksheet Functions | |||
| Desperately needing furmula help | Excel Discussion (Misc queries) | |||
| OR Functions in a Conditional Formatting Furmula | Excel Worksheet Functions | |||
| Furmula Dependent Cell References | Excel Discussion (Misc queries) | |||
| Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Threaded Mode
