The Lower group configures the lower color point used by fill conditional formatting.
Lower Color
Select the color used for the lower part of the configured range.
Lower Color Opacity
Adjust the transparency of the lower color.
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.
Lower Color Function
Select the function used to calculate the lower threshold when Lower 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.
Available source, function, reference-series, percentile, and start-value settings depend on the selected Color Mode.
Was this helpful? Thank you for your feedback!
Sorry about that.
How can we improve it?