问如果两个条件满足Excel条件格式

EN

Dim rng As Range, cell As Range, previouscell As Variant

Set rng = Sheet1.Range("F22:F61") 'set your range

For Each cell In rng
    If cell.Value <= 0.02 Then
        cell.Interior.Color = vbYellow 'color for the values <=0.02
        If cell.Value > previouscell Then
            previouscell = cell.Value
        End If
    End If
Next

For Each cell In rng
    If cell.Interior.ColorIndex > 0 Then
        If cell.Value = previouscell Then
            cell.Interior.Color = vbRed 'color for max value
        End If
    End If
Next

=A1=MAX(IF($A$1:$A$20<=0.02,$A$1:$A$20))

=AND($XFB9<=0.02,D9=AGGREGATE(14,6,D$9:D$100/($XFB$9:$XFB$100<=0.02),1))