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?

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?

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?

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?