Hello, I basically have 50 worksheets, each work sheet has 2 tables in it. An old one and a new one they all have the same titles etc, I need to compare the data. For instance A2-A43 is the old then A46-A87 is the new. Now what I want to do is if a change is present between the two of them highlight it red... Example A2 10 A3 5 A4 5 A46 10 A47 5 A48 10
This question generated 18 answers. To proceed to the answers, click here.
This thread is current as of September 18, 2014.
For more resources for Microsoft Excel:
This article includes the following tags: