I am running Filemaker Pro v8.5 under Win XP.
How can I conditionally colour the output of a Calculation Field?
I have been using the following formulation (kindly received from this forum) to conditionally colour the text in a Text input field. I use the Auto-enter Calculation Tab, then declick the do not replace existing value.
It works well, but I have not found a way to use the idea in a Calculation Field, which (obviously) already has a calculation in it. I have tried using "AND" after the original calculation formula, and then inserting this idea, but I cannot get it to work, and it seems in fact to mess up the recalculation of the calculation field when that is otherwise necessary.
Would appreciate guidance.