Excel 2010 Identifying data changed in cells and Identifying the changed rows

I have a large spreadsheet and need to visually see any changes made to the data on it. I also need to be able to identify by a column which rows have changed. All I have now is the below and it's not exactly what I'm looking for as it will change the fill and font color even if you retype the same thing in the cell. I only need it it do that if the data itself has changed.

I have no clue as to how to put a 'Y' in a cell column if any data on that row has changed.

Please help.

Please Login or Register  to view this content.

Define a global variable and use a selection change event to store the current/previous value when a cell is selected. Then, if/when the cell changes, compare the new current value to the previous value. If they're different use your highlighter code.

And use

Please Login or Register  to view this content.

for example to set the flag for the row.


Regards, TMS

Something like this:

Please Login or Register  to view this content.

Regards, TMS

You're welcome.


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.