Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looking to add color code alert | Excel Worksheet Functions | |||
How do I add an alert message upon a user closing the workbook? | Excel Discussion (Misc queries) | |||
Modified Color Option | Excel Discussion (Misc queries) | |||
Changing txt input into a modified orientation. | New Users to Excel | |||
Data Entry Alert in User Form | Excel Discussion (Misc queries) |