Enable Middle Color to add an optional middle color point to fill conditional formatting.
Middle Color
Select the color used for the middle point of the configured range.
Middle Color Opacity
Adjust the middle color opacity from 0 (fully transparent) to 100 (fully opaque).
Middle Color Source
Select how the middle threshold is determined.
- This Series – calculate the threshold from the selected series.
- Constant Value – enter a fixed threshold value.
- Another Series – calculate the threshold from another series.
Middle Color Function
When Middle Color Source is This Series, select the function used to calculate the threshold.
- Above Min – place the middle point above the minimum series value.
- Average (default) – use the average series value.
- Percentile – use a specified percentile of the series values.
Middle settings are available when Middle Color is enabled. Additional controls depend on the selected source and function.
Was this helpful? Thank you for your feedback!
Sorry about that.
How can we improve it?