Hello Colin,
Your formula should look something like this: If($C_FieldA > $C_FieldB, 'Red', 'Green')
$C_FieldA and $C_FieldB are the API names of the fields. 'Red' is the color if condition is TRUE and 'Green' is the color if condition is FALSE (provided both 'Red' and 'Green' are valid options in the picklist).
Please let me know if this helps.
Comment actions