View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Ron is offline
external usenet poster
 
Posts: 250
Default Need help with LEN? function

Thanks Everyone!

"David Biddulph" wrote:

"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