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.
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.