Conditional Formatting for Changes to cells

  • Thread starter Thread starter Dick Stapleton
  • Start date Start date
D

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
 
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
 
Back
Top