Showing the $ value difference

Solved/Closed
KirstyLee - 13 Nov 2015 à 05:24
 KirstyLee - 13 Nov 2015 à 19:38
Hello,
I am using Excel 2016.. and need some help.
I am doing a budgeting sheet and cant figure out how to do the following;
Column A - Budget $
Column B - Actual $
Column C - +/- $
I would like Column C to show the dollar amount as well as a + or - if the value in Column B is less than or greater than the value in column A.
I would also like the color to be green if - and to be red if +

Please help :)


1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
13 Nov 2015 à 09:48
You can use formula to get the difference like b2- b2 and then apply the format similar to
"[Green]-#,##0.00_);[Red]+#,##0.00"
Thank you :)