1. 

   ptwuk
   Member

   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.

   Posted 1 month ago #
2. 

   Hui
   Excel Ninja

   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

   Posted 1 month ago #

RSS feed for this topic

Reply

You must log in to post.