"P Sitaram" wrote:

=(LEN(C4)*(C4<A1))



Thanks for that it worked perfectly. How does that formula work?

I looked in the excel help pages for the LEN command but it was as much use
as a chocolate fire guard. It did not explain anything to me.