RED 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 red component of a color.

RED(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 (like RGB or HSL), or a reference to a cell that contains a color index or color result.

Return Value

Number

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, this function returns 0 (black).

RED(22)

Returns 51 if the document uses the default Microsoft Office Visio color palette, where dark gray is the color at index 22.

RED(Char.Color)

Returns the value of the red component of the current font color.

RED(RGB(10, 20, 30))

Returns 10.

Show: