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!

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2