Percent Saving Visual

[kristyval]

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

[Limor_OP]

Hi,
You want to color a loss differently than a saving?

Can you upload your excel file, and not just a screen shot?
Thanks

[kristyval]

attachment added for example. my goal is to flip the negative and positive values for "percent savings" .. because a savings would be a % decrease.

[bebo021999]

Put and negative sign before?

=-(D6-D5)/D5