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

=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

"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

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