VBA to highlight changed cells

[frateg8r]

I have several workbooks that have shipping data that I share with clients; I update the sheets throughout the day and then email them to the client at the end of the day. My goal is to implement a code that will highlight any cells that were changed that day, making it easy for the client to see only what has changed.

I've reviewed and tested the Excel change tracking function - it does not work for this purpose. I do not believe any conditional formatting will work, as this needs to be based on an event handler to the best of my knowledge.

I've perused this forum, and many many Google pages, to no avail. In fact, the closest code I've found to accomplish this is found at Can excel automatically highlight a cell when I make a change in box ? - Yahoo Answers and sadly, even that did not work (it's not quite what I was shooting for, but would have been a nice starting point if even that code had worked in my test.)

So, I am looking for any feedback on a decent starting point to resolve this challenge.

Thanks to all the folks willing to pony up some time and knowledge on my behalf.

Bob

 

[frateg8r]

Isn't that what you wanted?

yes, except that the new day's changes were not highlighting. I'm going to try mole's fix and see if that does the trick.

 

[mole999]

I think part of the Date Serial issue is that your in Florida, and I'm expecting just using a whole date numeric value travels better than a alternative