using colour to track changes
 

I am working on a very large spreadsheet. I want to show each day's new or
changed input in a different colour from the previous day (or few days). How
do I manage that without changing the colours for the whole spreadsheet, and
without having to format each cell as I go?