SetColor
Sets the font color property to the specified font. 💡 This method will work only with the text format of the cell.
Syntax
expression.SetColor(Color);
expression - A variable that represents a ApiFont class.
Parameters
| Name | Required/Optional | Data type | Default | Description |
|---|---|---|---|---|
| Color | Required | ApiColor | Font color. |
Returns
This method doesn't return any data.
Example
Change the color of specific text characters in a cell in a spreadsheet.
// How do I apply a custom color to part of the text inside a cell in a spreadsheet?
// Paint a selected run of characters with an RGB color value in a spreadsheet.
let worksheet = Api.GetActiveSheet();
let range = worksheet.GetRange("B1");
range.SetValue("This is just a sample text.");
let characters = range.GetCharacters(9, 4);
let font = characters.GetFont();
let color = Api.CreateColorFromRGB(255, 111, 61);
font.SetColor(color);