Conditional Format a field based on other fields values?
I don't see it in the options, but is it at all possible to change the conditional format of a specific field based on the value of another field within the layout?
Example: I'm tyring to have the fill color of the "NAME" field changed based on the whether the "Payment Date" and "Check Number" fields are both empty.
Is that possible?
Running: FMPro 11.0v3 on Windows.
Yes. Under Condition change value is to Formula is : IsEmpty(payment::paymentdate) and IsEmpty(payment::checknum) and then set your fill color to the desired color.
"and" in the formula means both fields have to be empty. You could use "or" and either field being empty would trigger condition.
This works for FM12.