Sub Décaler()
Dim decal As Byte, c As Range
decal = 3 'paramètre > 0 et < 12 à adapter
For Each c In Intersect(ActiveSheet.[C:C], ActiveSheet.UsedRange)
If c = "Plannifié" Then
c(1, 2).Resize(, 12 - decal).Copy c(1, 2 + decal)
c(1, 2).Resize(, decal).ClearContents
c(1, 2).Resize(, decal).Interior.ColorIndex = xlNone
End If
Next
End Sub