This conditional formatting type is used to format the cells with values greater or less than the average.
To set up formatting for the cells with value greater or less than the average, use the Conditional Formatting group of parameters on the side panel.
Select the type of formatted values: greater or less than the average.
Determine the settings on the Settings tab in the Conditional Formatting group of parameters:
Determine the settings on the Advanced tab in the Conditional formatting group of parameters:
See also:
Setting Up Conditional Formatting
Open the Conditional Formatting group of parameters
Settings button on the