Compare 2 worksheets of same size and highlight changes in different colour

[Jessie15]

I am completely new to VBA. I have 2 worksheets of the same size (about 4000 rows), cells containing either text, time or date data. I need to compare the new worksheet with the old and highlight anything that has changed on the new with a different colour. I currently do the exercise in Excel by creating a 3rd worksheet and then using the formula IF('new'!B2='old'B2,TRUE,'old'!B2) but this isn't ideal as the data that has stayed the same is replaced by 'TRUE' and the worksheet is therefore only partially useful. Trying to figure it out in VBA and failing miserably.

Any help (in very simplistic language please!) would be greatly appreciated.

 

[Norie]

The conditional formatting I used was pretty simple, I don't know where you got the $W:$AR from.

First part - selected A2:10, Format>conditional formatting... cell value is. not equal , then =A13 and formatted as green.

Second part - selected A13:E21, Format>conditional formatting... cell value is. not equal , then =A2 and formatted as red.

An advantage of conditional formatting it it's dynamic, if you use (non-event) code then you'll have to run it every time you want to update things.