Access gradient (color) conditions in Conditional
.
Each conditional format rule may contain a single gradient condition. A gradient condition is
defined by three points along a number scale (min, mid, and max), each of which has a color, a
value, and a Interpolation
. The content of a cell is
compared to the values in the number scale and the color applied to the cell is interpolated
based on the cell content's proximity to the gradient condition min, mid, and max points.
// Logs all the information inside gradient conditional format rules on a sheet. // The below snippet assumes all colors have ColorType.RGB. const sheet = SpreadsheetApp . getActiveSheet (); const rules = sheet . getConditionalFormatRules (); for ( let i = 0 ; i < rules . length ; i ++ ) { const gradient = rules [ i ]. getGradientCondition (); const minColor = gradient . getMinColorObject (). asRgbColor (). asHexString (); const minType = gradient . getMinType (); const minValue = gradient . getMinValue (); const midColor = gradient . getMidColorObject (). asRgbColor (). asHexString (); const midType = gradient . getMidType (); const midValue = gradient . getMidValue (); const maxColor = gradient . getMaxColorObject (). asRgbColor (). asHexString (); const maxType = gradient . getMaxType (); const maxValue = gradient . getMaxValue (); Logger . log ( `The conditional format gradient information for rule ${ i } : MinColor ${ minColor } , MinType ${ minType } , MinValue ${ minValue } , MidColor ${ midColor } , MidType ${ midType } , MidValue ${ midValue } , MaxColor ${ maxColor } , MaxType ${ maxType } , MaxValue ${ maxValue } ` ); }
Methods
Method | Return type | Brief description |
---|---|---|
Color
|
Gets the color set for the maximum value of this gradient condition. | |
Interpolation
|
Gets the interpolation type for the maximum value of this gradient condition. | |
String
|
Gets the max value of this gradient condition. | |
Color
|
Gets the color set for the midpoint value of this gradient condition. | |
Interpolation
|
Gets the interpolation type for the mid-point value of this gradient condition. | |
String
|
Gets the mid-point value of this gradient condition. | |
Color
|
Gets the color set for the minimum value of this gradient condition. | |
Interpolation
|
Gets the interpolation type for the minimum value of this gradient condition. | |
String
|
Gets the minimum value of this gradient condition. |
Detailed documentation
get
Max
Color
Object()
Gets the color set for the maximum value of this gradient condition. Returns null
if
the color hasn't been set.
Return
Color
— The color set for the maximum value of this gradient condition or null
.
get
Max
Type()
Gets the interpolation type for the maximum value of this gradient condition. Returns null
if the gradient max type hasn't been set.
Return
Interpolation
— the interpolation type for the maximum value of this gradient condition or null
get
Max
Value()
Gets the max value of this gradient condition. Returns an empty string if the Interpolation
is MAX
or if the max value hasn't been
set.
Return
String
— the maximum value if specified or an empty string
get
Mid
Color
Object()
Gets the color set for the midpoint value of this gradient condition. Returns null
if
the color hasn't been set.
Return
Color
— The color set for the midpoint value of this gradient condition or null
.
get
Mid
Type()
Gets the interpolation type for the mid-point value of this gradient condition. Returns null
if the gradient mid type hasn't been set.
Return
Interpolation
— the interpolation type for the mid-point value of this gradient condition or null
get
Mid
Value()
Gets the mid-point value of this gradient condition. Returns an empty string if the gradient mid value hasn't been set.
Return
String
— the mid-point value or an empty string
get
Min
Color
Object()
Gets the color set for the minimum value of this gradient condition. Returns null
if
the color hasn't been set.
Return
Color
— The color set for the minimum value of this gradient condition or null
.
get
Min
Type()
Gets the interpolation type for the minimum value of this gradient condition. Returns null
if the gradient min type hasn't been set.
Return
Interpolation
— the interpolation type for the minimum value of this gradient condition or null
get
Min
Value()
Gets the minimum value of this gradient condition. Returns an empty string if the Interpolation
is MIN
or if the min value hasn't been
set.
Return
String
— the minimum value if specified or an empty string