View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 618
Default Need help with LEN? function

"Ron" wrote in message
...
I'm stuck and need help with conditional formating based on the number of
characters in adjacent columns. Here is the logic.

If columB+columnC exceeds 31characters, format columnC as red&bold text


Condition Formatting:
Format is =(LEN(B1)+LEN(C1)31)
--
David Biddulph