Sub worksheet_change(ByVal Target As Range)
Dim val, val2, val3 As Variant
With Target
val2 = Sheets('Objectifs').Cells(.Row, .Column - 2).Value
val3 = Sheets('Objectifs + ou - 5%').Cells(.Row, .Column - 2).Value
'val = Round(cell.Value, 3)
val = Application.WorksheetFunction.Round(.Value, 3)
If .Value = Empty Then
MsgBox 'L'arrondi VBA est : ' & val, vbOKOnly
.Interior.ColorIndex = 2
.Font.ColorIndex = 1
ElseIf .Value >= 0 And val = val2 + 0.001 And val <= val3 + 0.001 - 1E-16 Then
MsgBox 'L'arrondi VBA est : ' & val, vbOKOnly
.Interior.ColorIndex = 36
.Font.ColorIndex = 1
Else: MsgBox 'L'arrondi VBA est : ' & val, vbOKOnly
.Interior.ColorIndex = 40
.Font.ColorIndex = 1
End If
End With
End Sub