| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell text length conditional formatting - Excel 2003
i have a sheet with data in cells A1:D250. i would like to apply conditional
formatting to any cell in the range that has a text length over 15 characters, is this possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell text length conditional formatting - Excel 2003
Sorry, not without VBA coding.
However, you could consider using Data Validation to limit the number of characters entered into a cell with an alert given when it exceeds 15 characters. "Manc Shaun" wrote: i have a sheet with data in cells A1:D250. i would like to apply conditional formatting to any cell in the range that has a text length over 15 characters, is this possible? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell text length conditional formatting - Excel 2003
Select A1:D250 range and enter =LEN(A1)15 in CF formula field!
Regards, Stefi €˛Manc Shaun€¯ ezt Ć*rta: i have a sheet with data in cells A1:D250. i would like to apply conditional formatting to any cell in the range that has a text length over 15 characters, is this possible? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell text length conditional formatting - Excel 2003
You can use FORMULA IS and test for Len(A1)15
"Manc Shaun" wrote: i have a sheet with data in cells A1:D250. i would like to apply conditional formatting to any cell in the range that has a text length over 15 characters, is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| limit text length in a text box in excel 2003 | New Users to Excel | |||
| Conditional Formatting based on text within a cell w/ text AND num | Excel Worksheet Functions | |||
| Excel 2003 print problem with conditional formatting cell selected | Excel Discussion (Misc queries) | |||
| How do I set up a text cell in Excel with restricted length? | Excel Discussion (Misc queries) | |||
| Wrap text limits in Excel 2003 cell formatting | Excel Discussion (Misc queries) | |||
Linear Mode
