Forum Discussion
Showing two Values in single cell (+/- change)
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.
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.