View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default 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?