AddAboveAverage 方法 (Excel) FormatConditionsFormatConditions.AddAboveAverage method (Excel)

返回一个新的**AboveAverage** 对象, 该对象代表指定区域的条件格式规则。Returns a new AboveAverage object representing a conditional formatting rule for the specified range.

语法Syntax

表达式AddAboveAverageexpression.AddAboveAverage

_表达式_一个代表**FormatConditions** 对象的变量。expression A variable that represents a FormatConditions object.

返回值Return value

AboveAverage对象AboveAverage object

说明Remarks

AboveAverage 对象用于查找单元格区域中高于或低于平均或标准偏差的值。The AboveAverage object is used to find values above or below an average or standard deviation in a range of cells. 例如, 您可以在年度绩效考核中查找以上平均执行者, 也可以在质量评级中查找低于两个标准偏差的制造材料。For example, you can find the above average performers in an annual performance review, or you can locate manufactured materials that fall below two standard deviations in a quality rating.

支持和反馈Support and feedback

有关于 Office VBA 或本文档的疑问或反馈?Have questions or feedback about Office VBA or this documentation? 请参阅 Office VBA 支持和反馈,获取有关如何接收支持和提供反馈的指南。Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.