TextColor()

TextColor()

Category: Text Formatting

Syntax: TextColor (text; RGB (red; green; blue))

Parameters: text ”any text string or expression that returns a text string; RGB (red;green;blue) ”a function that accepts three parameters from 0 to 255 and returns a number representing a color . See the RGB() definition.

Description:

Returns the text string in the color specified by the RGB parameter.

Examples:

 TextColor ("this text will be blue"; RGB (0;0;255)) 

Returns this text will be blue , formatted in blue.

 TextColor ("this text will be red"; 16711680) 

Returns this text will be red , formatted in red.

Comments:

Use the TextColor() function within text expressions to emphasize words:

 "We will have " & TextColor (NumberItems;RGB (255;0;0)) & " errors per cycle. Unacceptable!" 

TextColor() can also be used for conditional text formatting. The following calculation highlights losses in red:

 Let (Profit = GetAsText (Earnings  Expenditures);    Case (Profit > 0; TextColor (Profit; RGB(0;0;0));       Profit < 0; TextColor (Profit; RGB(255;0;0));       "")) 

If a field is formatted in the Number Format dialog, some options override the TextColor() function. For example, conditional color for negative numbers overrides TextColor , unless the user has clicked into the field being formatted.