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
|