Is it possible for some kind of formula to determine if a cell value increased or decreased without making a copy of the cell's value beforehand?
I have a cell A1 that gets updated every 15 minutes by a 'link to external data' and I want to color another cell B1 based on if A1 increased (green) from last time or if A1 decreased (red) or if A1 stayed the same (black)