LIGHTNESS

Syntax

=LIGHTNESS(color)

Arguments

ArgumentTypeDescription
colorColorThe color

Examples

=LIGHTNESS("#bf4040")0.5
Gets the lightness for the color represented by the hex color code #bf4040 (dark red)

=LIGHTNESS(RGB(255, 255, 255))1
Gets the lightness for a color having an RGB value of white

=LIGHTNESS(0)#ERROR!
Attempts to get the lightness from an integer, which is invalid because it cannot be converted to a color