Bug in conditional formatting?
I have a conditional format:
PatternCount ( Field1; "¶") > 1 /* Then change font color on warning message */
When I have 1 carriage return in Field1, the font changes when it should not. To verify there is only one carriage return, I wrote a one line script with a custom dialog whose message panel contains:
PatternCount ( Field1; "¶")
and when executed, returns 1 (one).
Why is the conditional format logic returning true if there is only one carriage return in the field?
FWIW, the second condition (there are 2) is
PatternCount ( Field1; "¶") = 0 /* Change warning message to another color */