# 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 = 0xff0000, Red; Max = 0xffffff
Negative | < 0 | Specifies the LED color that is displayed when Status is negative. Default Color = 0xffff00, Yellow; 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.

Outputs

Results | An LED status light element.