excel-vba Conditional formatting using VBA FormatConditions.AddAboveAverage
Example
With Range("E1:E100").FormatConditions.AddAboveAverage
.AboveBelow = xlAboveAverage
With .Font
.Bold = True
.ColorIndex = 3
End With
End With
Operators:
| Name | Description |
|---|---|
| XlAboveAverage | Above average |
| XlAboveStdDev | Above standard deviation |
| XlBelowAverage | Below average |
| XlBelowStdDev | Below standard deviation |
| XlEqualAboveAverage | Equal above average |
| XlEqualBelowAverage | Equal below average |
