Need help with LEN? function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
=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.
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with conditional formatting 1
Len & Trim Function 6
Macro / VBA Help 2
COUNTIF Function 4
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
How to choose maximum value 7
max 7
Conditional formatting based on adjacent cell? 1

Back
Top