Return to FileMaker.com
Changing text color based on calculation
I want to change the color of the text if one value is greater than the other.
This is what I wrote but it doesn't seem to work.
Case ( amount_contracted = amount_paid ; RGB ( 0 ; 0 ; 0 ) ; amount_contracted < amount_paid; RGB ( 178 ; 34 ; 34 ) ; amount_contracted > amount_paid ; RGB ( 0 ; 100 ; 0 ) )
What's the context?
Is this a calculation field, auto-entered calculation, a script step?
any reason why you don't want to use conditional formatting here?
Retrieving data ...