I'm using a spreadsheet for project management. What would be useful is if I could highlight the changes since the last update so that people would not have to trawl through the sheet to find out what has changed. I have looked at conditional formatting but have not been able to identify a solution. Obviously I only need the highlight to appear when new information is entered into the cell, not when people just open to view the file.
I also need to remove the highlighting from previous updates before I make current changes.
I also need to remove the highlighting from previous updates before I make current changes.