1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
| Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.ScreenUpdating = False
For Each Cell In Range("a3:a2000")
If Cells(Cell.Row, 44) = "REFUS CAT" Or Cells(Cell.Row, 44) = "CLIENT/PROSPECT INTERNE" Or Cells(Cell.Row, 44) = "SANS AUTO" _
Or Cells(Cell.Row, 49) = "REFUS CAT" Or Cells(Cell.Row, 49) = "CLIENT/PROSPECT INTERNE" Or Cells(Cell.Row, 49) = "SANS AUTO" _
Or Cells(Cell.Row, 54) = "REFUS CAT" Or Cells(Cell.Row, 54) = "CLIENT/PROSPECT INTERNE" Or Cells(Cell.Row, 54) = "SANS AUTO" _
Or Cells(Cell.Row, 59) = "REFUS CAT" Or Cells(Cell.Row, 44) = "CLIENT/PROSPECT INTERNE" Or Cells(Cell.Row, 44) = "SANS AUTO" _
Or Cells(Cell.Row, 64) = "REFUS CAT" Or Cells(Cell.Row, 64) = "CLIENT/PROSPECT INTERNE" Or Cells(Cell.Row, 64) = "SANS AUTO" _
Or Cells(Cell.Row, 69) = "REFUS CAT" Or Cells(Cell.Row, 69) = "CLIENT/PROSPECT INTERNE" Or Cells(Cell.Row, 69) = "SANS AUTO" _
Or Cells(Cell.Row, 74) = "REFUS CAT" Or Cells(Cell.Row, 74) = "CLIENT/PROSPECT INTERNE" Or Cells(Cell.Row, 74) = "SANS AUTO" _
Or Cells(Cell.Row, 79) = "REFUS CAT" Or Cells(Cell.Row, 79) = "CLIENT/PROSPECT INTERNE" Or Cells(Cell.Row, 79) = "SANS AUTO" _
Or Cells(Cell.Row, 84) = "REFUS CAT" Or Cells(Cell.Row, 84) = "CLIENT/PROSPECT INTERNE" Or Cells(Cell.Row, 84) = "SANS AUTO" _
Or Cells(Cell.Row, 89) = "REFUS CAT" Or Cells(Cell.Row, 89) = "CLIENT/PROSPECT INTERNE" Or Cells(Cell.Row, 89) = "SANS AUTO" _
Or Cells(Cell.Row, 94) = "REFUS CAT" Or Cells(Cell.Row, 94) = "CLIENT/PROSPECT INTERNE" Or Cells(Cell.Row, 94) = "SANS AUTO" _
Or Cells(Cell.Row, 99) = "REFUS CAT" Or Cells(Cell.Row, 99) = "CLIENT/PROSPECT INTERNE" Or Cells(Cell.Row, 99) = "SANS AUTO" _
Or Cells(Cell.Row, 104) = "REFUS CAT" Or Cells(Cell.Row, 104) = "CLIENT/PROSPECT INTERNE" Or Cells(Cell.Row, 104) = "SANS AUTO" _
Then Range("a" & Cell.Row & ":dd" & Cell.Row).Interior.ColorIndex = 3
If Cells(Cell.Row, 45) = "OUI" Or Cells(Cell.Row, 50) = "OUI" Or Cells(Cell.Row, 55) = "OUI" Or Cells(Cell.Row, 60) = "OUI" _
Or Cells(Cell.Row, 65) = "OUI" Or Cells(Cell.Row, 70) = "OUI" Or Cells(Cell.Row, 75) = "OUI" Or Cells(Cell.Row, 80) = "OUI" _
Or Cells(Cell.Row, 85) = "OUI" Or Cells(Cell.Row, 90) = "OUI" Or Cells(Cell.Row, 95) = "OUI" Or Cells(Cell.Row, 100) = "OUI" _
Or Cells(Cell.Row, 105) = "OUI" Then Range("a" & Cell.Row & ":dd" & Cell.Row).Interior.ColorIndex = 40
If Cells(Cell.Row, 48) = "RDV" Or Cells(Cell.Row, 53) = "RDV" Or Cells(Cell.Row, 58) = "RDV" Or Cells(Cell.Row, 63) = "RDV" _
Or Cells(Cell.Row, 68) = "RDV" Or Cells(Cell.Row, 73) = "RDV" Or Cells(Cell.Row, 78) = "RDV" Or Cells(Cell.Row, 83) = "RDV" _
Or Cells(Cell.Row, 88) = "RDV" Or Cells(Cell.Row, 93) = "RDV" Or Cells(Cell.Row, 98) = "RDV" Or Cells(Cell.Row, 103) = "RDV" _
Or Cells(Cell.Row, 108) = "RDV" _
Then Range("a" & Cell.Row & ":dd" & Cell.Row).Interior.ColorIndex = 4
Next Cell
Application.ScreenUpdating = True
End Sub |
Partager