Hi,

So I have two tabs with the same data from this week and the previous week.

The data from this week has changed to the data from last week.

I want to highlight all the cells that have changed in this weeks data (sheet 1) red by using conditional formatting. The data from last week is in sheet 2.

Any help with this please. In my example, the formula should highlight cells: C4, D4 and D6.

Many thanks.example v76.xlsx