Correction...

my post should say...

this will return true if THE LENGTH OF A1 does
not = 5, since it's true it will


On Feb 7, 1:34 pm, Tim879 wrote:
You need to use a conditional stmt in the conditional format...

try putting this in the conditional format box...
=if(len(a1)=5,0,1)

this will return true if A1 does not = 5, since it's true it will
trigger your conditional format.

On Feb 7, 1:22 pm, 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