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 lower color opacity from 0 (fully transparent) to 100 (fully opaque).
Lower Color Source
Select how the lower 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.
Lower Color Function
When Lower Color Source is This Series, select the function used to calculate the threshold.
- Min (default) – use the minimum series value.
- Average – use the average series value.
- Percentile – use a specified percentile of the series values.
Available reference-series, percentile, and start-value controls depend on the selected Color Mode, source, and function.
Was this helpful? Thank you for your feedback!
Sorry about that.
How can we improve it?