Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Highlighting changes to a spreadsheet in a differing STYLE
Can anyone help with the following query:
I am trying to highlight the data entered during a week in a different colour to the normal default black. I have added a new STYLE but that only allows application to a set range of cells, but i want to be able to overkey existing data as well as enter NEW data and all the amendments are in a new colour say RED I have looked at TRACK CHANGES too but this just adds a flag and doesnt really HIGHLIGHT the change Please help us sad people Thanks |
#2
|
|||
|
|||
Highlighting changes to a spreadsheet in a differing STYLE
Press Alt + F11 to get to the Visual Basic Editor
On the left hand side, find the file you're working on, and double click on ThisWorkbook Its code window will open up. Insert the following lines of code: Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) Target.Font.ColorIndex = 3 End Sub Now, whenever you edit a cell, its font color will become red. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spreadsheet Style | Excel Discussion (Misc queries) | |||
Formula for Returning values in another spreadsheet | Excel Worksheet Functions | |||
Hyperlinking to Excel 2000 with a linked spreadsheet | Excel Discussion (Misc queries) | |||
Using Excel spreadsheet as input to Access | Excel Discussion (Misc queries) | |||
Spreadsheet merging problems | Excel Worksheet Functions |