I have a large worksheet (6,000+ rows) that I am continuously updating
I need to quickly and easily see all "recent" changes made as I scroll through
At present, the data in each worksheet cell are all in black (+ Times Roman)
fonts - I would like all changes and additions to be very apparent - in say
red - and this should ideally include changing data within a cell - say
changing "Note" to "Notes" with just the "s" showing up red
Then when I am happy with certain changes, I want to Format Paint them to
black as I scroll through - leaving only the queries and any new-new
additions, etc. continuing to show up in red - or even make newer changes in
a different colour again?
I've tried Track Change markups, but they are difficult to see and a bit
fiddly to read what correction I made in those little "PostIt" boxes....

Any ideas? Thanks