Alert user that row has been modified by changing row color

J

jubu

I would like to set up a spreadsheet of data so that if anything is modified
in a cell, the entire row changes color. Is this possible in Excel and if
so, how can it be done. I have tried the "track changes" but that does not
change the background color, it marks the cell. Thanks in advance for any
help.
 
B

Bernie Deitrick

jubu,

Copy the code below, right-click the sheet tab, select "View Code" and paste the code into the
window that appears. It will make the entire row red when any cell is changed....

HTH,
Bernie
MS Excel MVP

Private Sub Worksheet_Change(ByVal Target As Range)
Target.EntireRow.Interior.ColorIndex = 3
End Sub
 
J

jubu

--
jubu


Bernie Deitrick said:
jubu,

Copy the code below, right-click the sheet tab, select "View Code" and paste the code into the
window that appears. It will make the entire row red when any cell is changed....

HTH,
Bernie
MS Excel MVP

Private Sub Worksheet_Change(ByVal Target As Range)
Target.EntireRow.Interior.ColorIndex = 3
End Sub





Bernie - Thanks so much for you help and wisdom!!
Click to expand...
 
Top