Bonjour,
Une piste à explorer.
Cdlt.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim rngDP As Range, Cell As Range
If Target.CountLarge = 1 Then
If Target.HasFormula Then
Set rngDP = Target.DirectPrecedents
For Each Cell In rngDP
Cell.Interior.Color = vbYellow
Next Cell
Else
Me.Cells.Interior.Color = xlNone
End If
End If
End Sub