cell text length conditional formatting - Excel 2003

M

Manc Shaun

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?
 
J

JLatham

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.
 
S

Stefi

Select A1:D250 range and enter =LEN(A1)>15 in CF formula field!

Regards,
Stefi

„Manc Shaun†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Cell data entering slow! 0
Conditional formatting disappears when cell contents deleted 2
Paste to excel from word - auto format problem 1
Delete certain text from cells 2
Max Length in a row 1
Negative Conditional Formatting Excel 2003 2
Mail Merge Directory Conditional Page Break 0

Top