View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Martin ©¿©¬ @REMOVETHIS.plus.com
 
Posts: n/a
Default Change colour of data when changed

Hello
I have been using the code below in my worksheets to change the colour
of updated/edited data.
Now it doesn't seem to be working

Any ideas why?

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)

End Sub

Private Sub Worksheet_Change(ByVal Target As Range)
Target.Interior.ColorIndex = 8
End Sub

Martin
©¿©¬