HI everyone,
I am making a share portfoilo spreadsheet,and want an easy viewing profit or loss coloured cell. if i am making a profit i want green and if making a loss make red
so (amount invested £10,000 * current price £2) -( amount invested £100* purchase price £1)
Profit = £10,000
Bookmarks