I have a worksheet that produces a current share price in the same cell. A1 for instance. The price is updated on a regular basis but always remains in the same cell and always shows the current price. Is there a function or a way of keeping a record of the highest value displayed in that cell?