stdDev: An int ([XMLSCHEMA2] section 3.3.17) attribute that specifies the number of standard deviations above or below the average to format in the conditional formatting rule. This attribute MUST NOT exist if type is not equal to "aboveAverage" or if equalAverage is "true".
equalAverage: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies, together with aboveAverage, how the conditional formatting rule is applied as specified by the following table. This attribute MUST NOT exist if type is not equal to "aboveAverage".
Value of equalAverage
Value of aboveAverage
Meaning
"true"
"true"
Conditional formatting is applied to cells whose value is equal to or above the average value of cells in the range.
"true"
"false"
Conditional formatting is applied to cells whose value is equal to or below the average value of cells in the range.
"false"
"true"
Conditional formatting is applied to cells whose value is above the average value of all cells in the range plus stdDev and multiplied by the standard deviation of all cells in the range.
"false"
"false"
Conditional formatting is applied to cells whose value is below the average value of all cells in the range minus stdDev and multiplied by the standard deviation of all cells in the range.
