Return to FileMaker.com
Field/button that changes colour according to certain reqirements
How do I make the following:
IF number field A < number field B -10, THEN button = Green
IF number field B -10 < number field A < number field B, THEN button = Yellow
IF number field A > number field B, THEN button = Red
Although I'm quite new -- have you tried conditional formatting? You can set it to change the fill color based on a value or formula.
Retrieving data ...