Private Sub Worksheet_Change(ByVal Target As Range)
Cells(Target.Row, Target.Column).Interior.Pattern = xlNone
On Error GoTo fin
If Len(Target.Value) > 0 Then
If Target.Row < 14 Then
Cells(Target.Row + 1, Target.Column).Interior.color = 65535
Else
Cells(7, Target.Column + 1).Interior.color = 65535
Cells(7, Target.Column + 1).Select
End If
End If
Exit Sub
fin:
End Sub