Showing the $ value difference
Solved/Closed
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 :)
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 :)
Related:
- Showing the $ value difference
- Vostfr et vf difference - Guide
- Difference between qwerty and azerty - Guide
- Difference between intranet and extranet - Guide
- Difference between clear chat and delete chat in viber - Guide
- Seeders leechers difference - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Nov 13, 2015 at 09:48 AM
Nov 13, 2015 at 09:48 AM
You can use formula to get the difference like b2- b2 and then apply the format similar to
"[Green]-#,##0.00_);[Red]+#,##0.00"
"[Green]-#,##0.00_);[Red]+#,##0.00"
Nov 13, 2015 at 07:38 PM