Salut Titietdidi,
tu devrais lorgner du côté des MFC, non?
Mais bon, VBA, j'adore, alors...
Private Sub Worksheet_Change(ByVal Target As Range)
'
iRow = Range("C" & Rows.Count).End(xlUp).Row
'
If Not Application.Intersect(Target, Range("C2:C" & iRow)) Is Nothing Then
Select Case Target.Value
Case Is < 7000
Target.Interior.Color = RGB(255, 255, 0)
Case 7000 To 12000
Target.Interior.Color = RGB(0, 0, 255)
Case Is > 12000
Target.Interior.Color = RGB(255, 0, 0)
End Select
End If
'
End Sub
A+
Bonsoir oyobrans, nos post se sont croisés semble-t-il...
A+