The Lower group configures the lower color point used by outline conditional formatting.
Outline Lower Color
Select the color used for the lower part of the outline's configured range.
Outline Lower Color Opacity
Adjust the transparency of the lower outline color.
Outline Lower Color Source
Select how the lower 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 Lower Color Function
Select the function used to calculate the lower threshold when Outline Lower Color Source is set to This Series.
- Min – use the minimum series value.
- Average – use the average series value.
- Percentile – use a specified percentile of the series values.
Source and function settings are available only for an applicable Outline Color Mode. 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?