ColorLabel
Inserts a color label display element in the spreadsheet. The label fills the cell with the background color and writes text in the foreground color.
ColorLabel Inputs
| Parameter | Description |
|
Name |
Specifies a text string label to appear in the foreground. |
|
Fore Color |
Specifies the foreground color. |
|
Back Color |
Specifies the background color. |
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.