Top10.TopBottom (Excel)

Returns or sets one of the constants of the XlTopBottom enumeration, which determines if the ranking is evaluated from the top or bottom. Possible return values are xlTop10Bottom - Top 10 bottom values, xlTop10Top - Top 10 values.


ActiveCell.FormatConditions(1).TopBottom = xlTop10Bottom