Conditional formatting

[cpliu]

2 functions I need that I can't figure out:
1. Highlight cells if the total characters (space included) of a cell is over 40.
2. Highlight the cells with a number at the left column (or a specific column) of a cell is over 40. That column, each cell has a different number.

Thanks for any suggestions!

 

[Claus Busch]

Hi,

Am Thu, 3 May 2012 10:53:04 -0700 (PDT) schrieb cpliu:

2 functions I need that I can't figure out:
1. Highlight cells if the total characters (space included) of a cell is over 40.
2. Highlight the cells with a number at the left column (or a specific column) of a cell is over 40. That column, each cell has a different number.

select your table from A1:End
and then CF with the formula:
=OR(LEN(A1)>40,AND(LEN(B1)>40,ISNUMBER(A1)))


Regards
Claus Busch