Private Sub Worksheet_Change(ByVal R As Range)
Application.EnableEvents = False
If Not Intersect(R, Range("b2:b8000")) Is Nothing Then
If IsDate(ActiveCell.Offset(-1, 0)) Then ActiveCell.Offset(-1, 0).Interior.Color = vbYellow
If Day(R.Offset(0, 0)) > Day(R.Offset(-1, 0)) Or Month(R.Offset(0, 0)) > Month(R.Offset(-1, 0)) Then
R.Offset(0, 0).Interior.Color = vbYellow
R.Offset(-1, 0).Interior.Color = xlNone
End If
End If
Application.EnableEvents = True
End Sub