Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formating with len
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formating | Excel Discussion (Misc queries) | |||
Conditional Formating | Excel Discussion (Misc queries) | |||
Conditional Formating | Excel Worksheet Functions | |||
Conditional Formating | Excel Worksheet Functions | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) |