[COLOR="DarkSlateGray"]Function lire_couleur(cel As Range)
Application.Volatile
Select Case cel.Interior.ColorIndex
Case 2: lire_couleur = "en cours"
Case 3: lire_couleur = "KO"
Case 4: lire_couleur = "OK"
Case Else: lire_couleur = ""
End Select
End Function[/COLOR]
[COLOR="DarkSlateGray"]Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.Calculate
End Sub[/COLOR]
Function couleurFondTexte()
Application.Volatile
Select Case Range(Application.Caller.Address).Interior.ColorIndex
Case 3
couleurFondTexte = "Ok"
Case 4
couleurFondTexte = "Ko"
Case 6
couleurFondTexte = "En cours"
Case Else
couleurFondTexte = ""
End Select
End Function
[COLOR="DarkSlateGray"]Function couleurFondTexte2(cel As Range)
Application.Volatile
Set x = Application.Caller
Select Case cel.Interior.ColorIndex
Case 3
couleurFondTexte2 = "Ok"
Case 4
couleurFondTexte2 = "Ko"
Case 6
couleurFondTexte2 = "En cours"
Case Else
couleurFondTexte2 = ""
End Select
End Function[/COLOR]