Status

Inserts a simulated LED status light display element into the spreadsheet. The Status cell displays the specified value as a red, yellow, or green LED, with text labels for each color.

Inputs

Parameter

Description

Status

References a cell to monitor for its status.

Label

The text that is displayed when the status value is positive, 0, or negative.

Status Value
Positive	> 0	Specifies the text that is displayed when Status is positive.
Zero	= 0	Specifies the text that is displayed when Status is 0.
Negative	< 0	Specifies the text that is displayed when Status is negative.

Color

The LED color that is displayed when the status value is positive, 0, or negative.

Status Value		LED Color
Positive	> 0	Specifies the LED color that is displayed when Status is positive. Default Color = 0x00ff00, Lime; Max = 0xffffff
Zero	= 0	Specifies the LED color that is displayed when Status is 0. Default Color = 0xffff00, Yellow; Max = 0xffffff
Negative	< 0	Specifies the LED color that is displayed when Status is negative. Default Color = 0xff0000, Red; Max = 0xffffff

Note:

Named colors can be selected using the color picker control in the Property Sheet. The color can also be specified as Cell References to another cell that returns a color value as a 24-bit number.
Given red, green, and blue values in the range 0-255, an RGB color value can be calculated using the formula (red * 65536) + (green * 256) + blue. Expressed in hexadecimal, this is in the 0xRRGGBB format. For example, the hexadecimal constant 0xFF8020 translates to: red=255, green=128, blue=32.