Excel - Track Changes

[dbpaul]

I want to highlight a cell that has been changed. At prsent excel only puts a small marker in the corner of the cell when using Track Changes.

I want the whole cell to turn red as I am using very large sheets.

Thanks for the help

[Loz]

You can setup a short piece of code to achieve this.

First, you will have to take the worksheet out of change tracking mode.

Then, right-click on the worksheet tab name and select View Code from the pop-up menu. Then copy & paste in the following....

Please Login or Register  to view this content.

The Track Changes mode and worksheet sharing feature cannot be used at the same time as code, so if you want to keep a note of what was changed and by whom, this simple code could be enhanced to add for example a comment against the cell.