• Hot Topics

Excel Help greatly needed - Conditional formatting

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:

  • Excel
  • Microsoft Excel