[SIZE=2][COLOR=GRAY][B][I]DANS LE MODULE DE CODE DE LA FEUILLE[/I][/B][/COLOR]
[COLOR=NAVY]Private Sub[/COLOR] Worksheet_SelectionChange([COLOR=NAVY]ByVal[/COLOR] Target [COLOR=NAVY]As[/COLOR] Range)
[COLOR=GREEN]'myDearFriend![/COLOR]
[COLOR=NAVY]Static[/COLOR] ancCel [COLOR=NAVY]As[/COLOR] Range, ancCoul [COLOR=NAVY]As Integer
If Not[/COLOR] ancCel [COLOR=NAVY]Is Nothing Then[/COLOR] ancCel.Interior.ColorIndex = ancCoul
[COLOR=NAVY]Set[/COLOR] ancCel = ActiveCell
ancCoul = ancCel.Interior.ColorIndex
ancCel.Interior.ColorIndex = 6
[COLOR=NAVY]End Sub[/COLOR]
[/SIZE]