Showing the $ value difference [Solved/Closed]

Question

Showing the $ value difference [Solved/Closed]

Report

KirstyLee - Nov 13, 2015 at 05:24 AM
KirstyLee - Nov 13, 2015 at 07:38 PM

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 :)

Showing the $ value difference
Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Forum - Excel
Compare two excel sheets and highlight differences macro ✓ - Forum - Excel
What is the difference between seeders and leechers - How-To - P2P
Difference between usb fdd and hdd - How-To - USB
How to compare two Excel sheets with varying data ✓ - Forum - Excel

1 reply

Ask a question

rizvisa1 · Accepted Answer · 2015-11-13T09:48:14-0500

Answer 1 / 1

rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

767
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"

Report

KirstyLee
Nov 13, 2015 at 07:38 PM

Thank you :)

Showing the $ value difference [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!