Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Not Intersect(Target, Range("cellule inconnue")) Is Nothing Then
if Valeur cellule inconnue > Valeur cellule inconnue then
Range("o4").Interior.ColorIndex = 2
Range("q4").Interior.ColorIndex = 2
Range("o4").Font.ColorIndex = 2
Range("q4").Font.ColorIndex = 2
Else
Range("o4").Interior.ColorIndex = 4
Range("q4").Interior.ColorIndex = 4
Range("o4").Font.ColorIndex = 1
Range("q4").Font.ColorIndex = 1
End If
End If
Application.EnableEvents = False
End Sub