The conditional formatting rule is applied to cells with values above the average value of all cells in the range.
"false"
The conditional formatting rule is applied to cells with values below the average value of all cells in the range.
percent: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the conditional formatting rule is applied to a percentage of cells as specified by the following table. This attribute MUST NOT exist if type is not equal to "top10".
Value
Meaning
"true"
rank specifies the percentage of cells in the range to which conditional formatting is applied.
"false"
The conditional formatting rule is applied to the number of cells specified by rank.