Percentage Difference Between Two Numbers

[meppwc]

I am looking for a formula to help me track performance on my stocks.
Cell A1 is an established value that never changes, but the cell below it (A2) changes as my stock value changes.

I need the following 2 new cells
- Cell A3 will provide the difference between A1 and A2 in dollars (if A3 is a positive number, it needs to be black, but if it is a negative number it needs to indicate a loss (red, or minus sign or something indicitive)
- Cell A4 will provide the difference between A1 and A2 in percentage. (if A4 is a positive number, it needs to be black, but if it is a negative number it needs to indicate a loss (red, or minus sign or something indicitive)

 

[machopicho]

in A3
A1-A2
in A4
(A2-A1)/A1*100

 

[StillLearningExcel]

and go to format cells / custom and paste

in Type: _-£* #,##0.00_-;-£* #,##0.00_-;_-£* "-"??_-;_-@_-

and change the £ for % for the percentage