Showing the $ value difference [Solved/Closed]

 KirstyLee -
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 reply

Registration date
Thursday January 28, 2010
Last seen
August 2, 2020
You can use formula to get the difference like b2- b2 and then apply the format similar to
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Thank you :)

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!