Private Sub Worksheet_Change(ByVal sh As Object, ByVal c As Range)
sh = ActiveSheet.Name
If Left(sh, 1) = "C" Then
Set plage = Range("A1:G16")
If Not Application.Intersect(c, plage) Is Nothing Then
On Error Resume Next
s = Split(c, "*")
If IsError(s(1)) = True Then
c.Font.Bold = False
c.Font.Color = RGB(0, 0, 0)
Else
c.Characters(1, Len(s(0))).Font.Bold = True
c.Characters(1, Len(s(0))).Font.Color = RGB(30, 140, 0) '--vert
End If
End If
End If
End Sub