I am working with a large list in Excel 2003. One column is formatted as
general. Each cell in the column has numbers in it that look like this:
1234-1234. I want to have the cell turn red if there are not nine characters
in it.

I have selected conditinal formatting for the cell. I use fomula
=if(len(B4)<9) and tell it to make the cell red. It doesn't work. Can anyone
help me figure out why?

Thanks for any help given.