VBA
11.02.2005 10:48:42
Franz
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Range("D5") = "L" And Range("F5") > "1" Then Range("F5").Interior.ColorIndex = 36
If Range("D5") = "L" And Range("G5") > "1" Then Range("G5").Interior.ColorIndex = 36
If Range("D5") = "L" And Range("H5") > "1" Then Range("H5").Interior.ColorIndex = 36
If Range("D5") = "L" And Range("I5") > "1" Then Range("I5").Interior.ColorIndex = 36
If Range("D5") = "L" And Range("J5") > "1" Then Range("J5").Interior.ColorIndex = 36
End Sub
Gruß, Franz