The company I work for uses Excel to record meeting minutes, and this then
forms the basis of subsequent meeting minutes. Changes made during each
meeting are manually highlighted by means of a formatting change, such as a
colour change to indicate an added note. This means before each meeting, the
old minute has the colour changed to standard, and as we enter new
comments/notes, we have to select these and change the colour (it works but
is not an effective way).

How can I have Excel do this automatically, i.e. change the colour of new
entries/changes?

I have tried the Tracking Changes tool but it just leaves a marker where
there have been changes, and I have to place the cursor over each cell to see
the changes.