The Upper group configures the upper color point used by fill conditional formatting.
Upper Color
Select the color used for the upper part of the configured range.
Upper Color Opacity
Adjust the upper color opacity from 0 (fully transparent) to 100 (fully opaque).
Upper Color Source
Select how the upper 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.
Upper Color Function
When Upper Color Source is This Series, select the function used to calculate the threshold.
- Above Min – place the upper point above the minimum series value.
- Average (default) – use the average series value.
- Percentile – use a specified percentile of the series values.
- Max – use the maximum series value.
Available reference-series, percentile, and start-value controls depend on the selected source and function.
Was this helpful? Thank you for your feedback!
Sorry about that.
How can we improve it?