Option Explicit
Sub Selection_calendrier()
Dim vValeur As Single
Dim vCellule As Object
Dim vSelection As String
Sheets("Feuil2").Select
Range("vCellule").Select
Selection.Interior.Pattern = xlNone
vValeur = Val(InputBox("JOUR à selectionner "))
Selection.CurrentRegion.Select
For Each vCellule In Selection
If vCellule.Value = vValeur Then vSelection = vSelection & vCellule.Address & ","
Next
If Len(vSelection) > 0 Then
Range(Left(vSelection, Len(vSelection) - 1)).Select
Selection.Interior.ColorIndex = 3
End If
End Sub