So I have a numeric formula that calculates two fields to come up with a percentage savings between the two numbers. I am using this formula
Round([Monthly Sub Savings ($)_used for calculation]/ [Annual Single Issue Price_used for calculation],0.01)
The works great. What I want is that when the number is a negative number (-23%) I would like the number to show up as RED so that when we fill it in we see that right away to make it noticeable.
How do I do that?