Need help with LEN? function

R

Ron

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
 
D

David Billigmeier

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
 
S

Sloth

=LEN($B1)+LEN($C1)>31

Just remember that it won't count leading zeros unless B and C are formatted
as text. For example B2 contains the number 123 but is formatted to using
0000 to show as 0123. LEN(B2) will equal 3 and not four.
 
D

David Biddulph

Ron said:
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
Click to expand...

Condition Formatting:
Format is =(LEN(B1)+LEN(C1)>31)
 
Top