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