This program seems to do what your require. You can “try before you buy” and the price seems reasonable. This is another program that is a little more expensive, but offers a 30 free trial. This is a Freeware program that might be worth looking at. This is another Freeware program to try
As always, when downloading ANYTHING from the web check for viruses and spyware.
What, specifically, is the comparison based upon? There needs to be some index number or value you are comparing within yesterday’s and today’s data. An example would be somebody’s name. With this example, you would lookup person ‘A’ from today and compare to person ‘A’, from yesterday and then compare values. Whatever the index value is, you can use an ISERROR, INDEX ,and MATCH formula combination, as an example,
The ISERROR gives a NOMATCH value instead of #NA if no match is found (you can use any text or number value to replace NOMATCH). A conditional format can be added to each cell so that if a NOMATCH value is present, then the cell background changes to a selected color. Anytime you see this background color, you know a change has occurred to that cell.
I compare daily files using this method and it works great. There just has to be some index value to compare the data sets.
If this is confusing, I would suggest referencing the ‘Excel Bible’ book by Walkenbach & Underdahl.\
Excel 2007 has a compare feature.
Hope this helps!