sorry new to fm i have a +/- percentage range of a calculation in a portal. when i try to apply a conditional format all fields in column change text color. the formula is (a-b/a)*100. i guess the first question is can you have more than one condition on a field? ( if this then green if not red) or can this be two separate conditions?
i have created non stored fields and variables but nothing seems to work.
thanks in advance