Forum Discussion
Solved
Showing two Values in single cell (+/- change)
This seems like an easy fix or maybe not but i just cant figure it out. I am trying to show the %, Amount, or $ change from one cell to another. While retaining the current Value. For Exampl...
You cannot do this in B1 itself.
I'd create a formula in column C. In C1:
=TEXT(B1, "$0")& " (" & TEXT(B1-A1, "+$0;-$0") &")"
This can be filled down. You can use a similar format for cells with a general number or a percentage, but you'll have to create a separate formula for each of those.
Thank you again for all the help. My spreadsheet is coming along nicely. Im not curious, i know you can create an IF statement to change the font color. How would i add that into the previous formula you helped me with. The IF statement would be used to change the font to green/red for +/- values.
Would make it much easier to quickly see the progress and regression from period to period.
If you can help with this, that is.
You can change the font color for the entire cell by creating conditional formatting rules.
It is not possible to color part of the result of a formula differently from the rest.