B | C | D | |
5 | 2 | ||
6 | |||
7 | 1 | ||
8 | sonstwas | ||
9 | |||
10 | 1 | ||
11 | |||
12 | 1 | ||
13 | 0 |
verwendete Formeln | |
Zelle | Formel |
D8 | =WENN(B5<=C7; 0; "sonstwas") |
D13 | =WENN(B10<=C12; 0; "sonstwas") |
bedingte Formatierung | |||||||||
Zelle | Typ | Operator | Formel1 | Formel2 | Format | Unterstrichen | Schrift- farbe | Muster | Muster- farbe |
D8 | 1.Bed.: Formel ist | =B5<=C7 | 13408767 | ||||||
D13 | 1.Bed.: Formel ist | =B10<=C12 | 13408767 |
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Range("B5") <= Range("C7") Then
Range("D8").Interior.ColorIndex = 7
Range("D8") = 0
Else
Range("D8").Interior.ColorIndex = xlNone
End If
End Sub