Let's change the background color of any cell you change. Enter the
following macro in the worksheet code area:

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
Target.Interior.ColorIndex = 6
Application.EnableEvents = True
End Sub

Any cell you change will turn yellow.
--
Gary''s Student - gsnu200770


"Becky" wrote:

Is there a way that I can change the default on "Highlight Changes"

When making revisions in a cell, I would like the changes to be noted either
by shading the cell or changing the font color, making it easier to see the
changes being made.
---
BJY