Conditional format assistance

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

"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.

LEN returns the length of the cell entry, giving 0 when there is none.
So, the formula can result in:
0*0 = 0 i.e., FALSE
O*1 = 0 -do-
+ve number *0 = 0 -do-
+ve number*1 = +ve number i.e., TRUE