Select the cells to format and do the following:

Click FORMAT in the menu and select CONDITIONAL FORMATTING

Change CELL IS in condition 1 to FORMULA IS

In the formula field enter the following as a formula (No quotes),
substituting A1 in the formula with the starting cell in your selection range:
=LEN(A1)<5

Click the FORMAT button and click the PATTERNS tab, click the color flavor
of your choosing and click the OK command button to exit formatting and then
click the OK command button to exit conditional formatting.


--
Kevin Backmann


"doyree" wrote:

hello,

i have a question with conditional formating. please help.

a
00607
01505
132
12345

i wanted that if cell box contained less than 5 characters, it is fill with
red.
above is all digits stores in text. i made it text since some values have 0
in front.

i went to conditional formating and did
cell value is, not equal to, ="LEN(5)"
then fill box with red
i also tried ="LENB(10)" but that didn't work.

could you please help?

thank you