Conditional Formatting for Changes to cells

[Dick Stapleton]

I want to use either conditional formatting or change tracking to change the
font color on any changes made to a spreadsheet by a user. Just one user
will be using each spreadsheet but the changes are then submitted to someone
for data entry into the big iron.

Thanks

dick

 

[Bob Umlas]

Right-click the sheet tab, select View Code, enter this:

Private Sub Worksheet_Change(ByVal Target As Range)
Target.Interior.Color = vbRed
End Sub

Bob Umlas
Excel MVP