hi all,

I am trying to create a visual "percent savings" pricing tool that will also show when there is a loss. I have my % change formula in there, but from an optics perspective i am trying to show when there is a savings versus a loss, but because the way percentages are calculated, I cant conditionally format an absolute value to show as a negative when there is a loss. I hope that makes sense? in otherwords, i am trying to flip the positive and negative values.


Capture.PNG