Ray
Sorry correction (out of practise). Assume this weeks cell ref = e1 and last weeks = d1, in this weeks cell Choose Format, Conditional formatting, then choose "Formula is" and type = D2<>E2 then in formatting choose patterns and a colour. You can copy conditional formatting using the format painter.I.e with cursor in formatted cell, Click on format painter then Click and drag over remaining cells to be formatted.