DESATURATE function

DESATURATE (Color, Amount) DESATURATE (Color; Amount)

Color

Color Color

The color to desaturate.

Amount

Number Number

A number between 0 and 100 (inclusive), where 0 means that no modifications should be made and 100 means that the resulting color should be fully desaturated.

Returns

Color Color

A desaturated version of the given color.

Desaturates the given color by a specified amount. The implementation uses the Hue-Saturation-Lightness (HSL) color model to linearly decrease the saturation with the given ' amount. Use SATURATE to perform the reverse operation.

This function is not commonly supported by spreadsheets.

Examples

DESATURATE (Color.Red, 50)

DESATURATE (Color,Red; 50)

Returns a variant of the default red color, which has been desaturated by 50 percent.

DESATURATE ({ Color.Red, Color.Green }, 50)

DESATURATE ({ Color,Red; Color,Green }; 50)

Returns variants of the default red and green colors, which have both been desaturated by 50 percent.

DESATURATE ({ Color.Red, Color.Green }, { 50, 25 })

DESATURATE ({ Color,Red; Color,Green }; { 50; 25 })

Returns variants of the default red and green colors, which have been desaturated by 50 and 25 percent, respectively.