AW: Bedingte Formatierung > 3
03.03.2004 16:46:14
Willie
Hallo Silvia das geht nur mit VBA und zwar so!
Sub Makro1()
For i = 1 To 30
If Cells(i, 5).Value <= 60 Then
Cells(i, 5).Select
Selection.FormatConditions.Delete
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _
Formula1:="40"
Selection.FormatConditions(1).Interior.ColorIndex = 9
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _
Formula1:="50"
Selection.FormatConditions(2).Interior.ColorIndex = 4
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _
Formula1:="60"
Selection.FormatConditions(3).Interior.ColorIndex = 32
Else
Cells(i, 5).Select
Selection.FormatConditions.Delete
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _
Formula1:="65"
Selection.FormatConditions(1).Interior.ColorIndex = 22
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _
Formula1:="70"
Selection.FormatConditions(2).Interior.ColorIndex = 12
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _
Formula1:="75"
Selection.FormatConditions(3).Interior.ColorIndex = 33
End If
Next
End Sub
Sub Makro2()
Columns("E:E").Select
Selection.ClearFormats
Range("E1").Select
End Sub
Gruß Willie