In my list is a number field formated as %. Request has been made to apply a background color to the form field if the value is above a certain %. Applying a formatting rule should do the trick. Condition: [field]>[number]. It does work for fields not formatted as percentage. But I can't get it to work for % fields. While in edit mode the value is apparently only recognized as number and the color displays. When saved and in view mode, the rule is not applying.
Any suggestion to get around this?