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 How would I get it so that both A4 and A48 become highlighted, and also if I was to change the cell value to be the same would it then go away? As this is what I'm looking for. Regards , please reply today... I am struggling. Alex.

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