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 Conditional Formatting Removal 7
Negative Conditional Formatting Excel 2003 2
can conditional formatting varry the area it highlights based on c 3
Conditional formatting to every cell in a column 7
Excel 2007 conditional formatting bug? 2
Conditional Formatting 2
Conditional Formatting on "Any Text" entered in a cell 3
Conditional Formatting Minimim Value 2

Top