Hi

In a previous question on testing CF conditions I was directed to a website
xldynamic.com/source/xld.cfconditions.html. I need to use the function
listed as IsCFMet but it does not giving me the expected response when using
a formula condition.

As a check I created a condition cell (value is, equal to, 1, pattern red)
in A1 and in B1 used the function. It returned TRUE as expected. However,
the real formulas are more complex and when I entered an example in A2 of
Formula is, =LEN(A2)40, pattern red OR cell value is, equal to,="", pattern
blue the function returns FALSE when the cell is empty (instead of TRUE). If
I enter more than 40 characters to activate the other condition the function
returns TRUE (which is correct).

Is there something wrong with my conditional format or something which needs
changing in the code? I would be grateful for any help on this.

Thanks

G