Hiya, Folks. Hope all is well in these first days of Autumn (for the northern hemisphere anyway).

I have been asked by management where I work to enhance my company metrics file such that every new version of it must highlight with light blue fill and dark orange font any value that has changed since the last iteration. The worksheets within the file will always be the same, and the column headers also always the same.

We store our prior iterations of the file on Sharepoint. What I am essentially looking for is a VBA to add to the file that highlights in the manner described any values that have changed since the most recent iteration of the file, prior to the one presently being done.

Please let me know your thoughts on how to approach this. The more I think about it the more impossible this seems. Much thanks in advance for your time.

Aimee