If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Alert user that row has been modified by changing row color
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 |
#2
|
|||
|
|||
Alert user that row has been modified by changing row color
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" wrote in message ... 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 |
#3
|
|||
|
|||
Alert user that row has been modified by changing row color
-- 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" wrote in message ... 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!! |
Thread Tools | |
Display Modes | |
|
|