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.
--
jubu

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


"jubu" <(E-Mail Removed)> wrote in message
news:44DE1BE1-B9A7-41D9-B538-(E-Mail Removed)...
>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.
> --
> jubu

--
jubu


"Bernie Deitrick" wrote:

> 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
>
>
> "jubu" <(E-Mail Removed)> wrote in message
> news:44DE1BE1-B9A7-41D9-B538-(E-Mail Removed)...
> >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.
> > --
> > jubu
>
>
> Bernie - Thanks so much for you help and wisdom!!