This is probably a simple solution and im overthinking it.
I have a sheet that pulls in a price from an external website into lets say 'DASHBOARD!B2". This price updates every minute.
What I would like to do is copy this price to another sheet, 'HISTORY!A1' and then when the price changes I want the value in 'DASHBOARD!B2" to compare if the price has gone up or down (colour green/red), using conditional formatting to compare it against the value in 'HISTORY!A1'. (im fine doing the conditional formatting)
I cant use the usual cell equals formula as this would update the history cell at the same time as the dashboard cell so it wouldn't compare the values. So I need a way of it retaining the previous price for the current price to compare against.
Any ideas or help would be great.
Bookmarks