GREEN function

Microsoft Office ShapeSheet

GREEN function

See also

Returns the green component of a color. The return value is an integer in the range of 0 to 255, inclusive. The input is an index of a color in the document's color table, an expression that resolves to a custom color (like RGB or HSL), or a reference to a cell that contains a color index or color result. The function returns 0 for invalid input.

Syntax

GREEN(expression)

Remarks

The return value is a number in the range 0 to 255, inclusive, or a cell reference that resolves to an index. If expression is invalid, it returns 0 (black).

Example 1

GREEN(Sheet.4!FillForegnd)

Returns the green component of Sheet.4's fill foreground color.

Example 2

GREEN(11)

Returns 128 if the document uses the default Visio color palette, where dark yellow is the color at index 11.

Example 3

GREEN(RGB(10, 20, 30))

Returns 20.