Change the attributes as needed.

Private Sub Worksheet_Change(ByVal Target As Range)
Target.Font.ColorIndex = 5
Target.Font.Bold = True
Target.Interior.ColorIndex = 8
End Sub


MikeCM wrote:
I have a worksheet that I am asking a person to review (and only one
reviewer). I'm not keen on using 'track changes' to identify values in
cells, so I would like a macro to run automatically and (at a glance
and with impact) highlight changes by colouring the cell and choosing a
different font colour. Is there anything simple to do this? Thanks.

Mike