Need help with LEN? function
 

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

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

Need help with LEN? function
 

=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" 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

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

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