GREEN Function

Office 2013 and later

Last modified: March 09, 2015

Applies to: Office 2013 | Visio 2013

In this article
Syntax
Remarks
Example 1
Example 2
Example 3

Returns the green component of a color.

GREEN(expression)

Parameters

Name

Required/Optional

Data Type

Description

expression

Required

Varies

An index of a color in the document's color table, an expression that resolves to a custom color (such as RGB or HSL), or a reference to a cell that contains a color index or color result.

Return Value

Integer

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).

GREEN(Sheet.4!FillForegnd)

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

GREEN(11)

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

GREEN(RGB(10, 20, 30))

Returns 20.

Show: