Private Sub Worksheet_Change(ByVal Target As Range)
ActiveSheet.Unprotect "123"
Dim a, b, i
a = Array("C11", ) 'à adapter
b = Array("CHVSGRI") 'à adapter
For i = 0 To UBound(a)
'ActiveSheet.Unprotect "123"
b(i) = Replace(b(i), ",", Chr(130))
If Range(a(i)) = "" Then
Range(a(i)).Font.ColorIndex = 16
Range(a(i)).Font.Bold = False 'non gras
Range(a(i)) = b(i)
ElseIf Range(a(i)) <> b(i) Then
Range(a(i)).Font.ColorIndex = 1
Range(a(i)).Font.Bold = True 'gras, facultatif
End If
'ActiveSheet.Protect "123"
Next
'ActiveSheet.Protect "123"
If Application.Intersect(Target, Range("F12:F13")) Is Nothing Then Exit Sub
Select Case Target.Address
Case "$F$12"
Application.EnableEvents = False
Range("F13") = IIf(Target.Value = "Yes", "No", "Yes")
Case "$F$13"
Application.EnableEvents = False
Range("F12") = IIf(Target.Value = "Yes", "No", "Yes")
End Select
Application.EnableEvents = True
End Sub