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

Something like this?

Select C1
<Format
<Conditional Formatting
Choose "Formula Is" from drop down
Enter =LEN(B1)+LEN(C1)31
Then format as red bold
--
Regards,
Dave


"Ron" wrote:

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

Thanks