A question for the Excel gurus of the world ...

We are looking for a script/addon for Excel that will allow us to track
changes in Excel with a special twist ... we want to have a specified
cell (unique to each row) switched from a 0 to a 1 anytime any value in
that row is modified. Can this be done?

In addition ... if there is a way to have Excel highlight the
background of the cell(s) that have changed that would be cool too.

Looking forward to some feedback ...

Excel Novice