Change highlight colour of cell when new information is entered into the cell

[ptwuk]

I'm using a spreadsheet for project management. What would be useful is if I could highlight the changes since the last update so that people would not have to trawl through the sheet to find out what has changed. I have looked at conditional formatting but have not been able to identify a solution. Obviously I only need the highlight to appear when new information is entered into the cell, not when people just open to view the file.


I also need to remove the highlighting from previous updates before I make current changes.

 

[Hui]

Ptwuk


Try the following 2 macros which need to be put in a Worksheet Code Page in the VBA Project


Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

' This will clear Red Background Cells before save

For Each c In Range("A1:AA100") 'Set a range to suit

If c.Interior.ColorIndex = 3 Then c.Interior.ColorIndex = xlNone 'If Interior Color = Red (3) clear interior color

Next


End Sub


Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

' This will set a background color to Red when a cell changes


If Sh.Name = "Sheet1" Then Target.Interior.ColorIndex = 3 'Change sheet name to suit


End Sub


Change color codes to suit