The Upper group configures the upper color point used by outline conditional formatting.
Outline Upper Color
Select the color used for the upper part of the outline's configured range.
Outline Upper Opacity
Adjust the transparency of the upper outline color.
Outline Upper Color Source
Select how the upper threshold value is determined.
- This Series – calculate the threshold using values from the selected series.
- Constant Value – specify a fixed threshold value.
- Another Series – calculate the threshold using values from another series.
Outline Upper Color Function
Select the function used to calculate the upper threshold when Outline Upper Color Source is set to This Series.
- Above Min – use a value above the series minimum.
- Average – use the average series value.
- Percentile – use a specified percentile of the series values.
- Max – use the maximum series value.
Additional controls for constant values, referenced series, and percentiles depend on the selected source and function.
Was this helpful? Thank you for your feedback!
Sorry about that.
How can we improve it?