First of all it is great that so many people take extra time to try to help
others with problems in these discussion groups. My question is about
conditional formatting on a form to unshade a cell once a user enters
information into it.
I have looked through some of these postings and one person suggested a
conditional format for a form to "unshade" a cell when a person enters
something in it. The formula was =LEN(A1)<
What I wanted to know was what does the LEN stand for? The only option in
conditional formatting is if the cell or formula is something, then use this
format. Well if I put the format to the cell that if it is greater than or
less than zero, use no format. But what happens if the entry is actually
zero which happens in this particular form that I am working on? Is there
another formula to do that?

Thanks.