conditional formating with len
tried all formulas
yours did the magic!!
thanks!!!!!
"Gord Dibben" wrote:
CFFormula is =LEN($A1)<5 Format to red
Gord Dibben MS Excel MVP
On Thu, 7 Feb 2008 10:22:05 -0800, 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
|