REFERENCE
U.FORMAT_RANGE
Summary
Applies specified formats to specified range(s)
Syntax
Parameters
| Parameter | Required | Description |
|---|---|---|
range |
Yes | The range(s) to which formats will be applied. Supports use of hard-coded string "self" to refer to calling range |
settings |
Yes | The 2-column list of setting names and values to be applied. See table at bottom of this worksheet for currently supported settings. Alternatively, settings can be provided as a comma-delimited list of settings as |
[filter] |
No | An array of boolean and/or subtext values that determine whether formats are applied to corresponding cell in specified range(s) |
[block] |
No | If set to TRUE then method will not be calculated unless triggered by user interaction or calculated as a step in a script; If set to a number then will be throttled to not calculate more frequently than the specified number of seconds; make number negative to prevent auto recalc of blocked methods |
Behavior
The documented public interface is supported by the current U Add-in source signature and the maintained Usage Examples workbook. Optional parameters are shown in square brackets in the syntax above; omit the brackets when entering a formula.
Return Value
Returns the function result or action status described by the formula and parameters above. The maintained sources do not define a narrower, stable return contract for this function.
Examples
Notes
- Formula examples are preserved from maintained workbook usage and normalized to the current
U.prefix. - Complete formulas demonstrate working patterns; they do not imply that undocumented option values are supported.
- Where maintained sources do not specify every accepted value, default, or error message, this page does not infer one.
- For functions that perform actions, use a visible trigger or supported block/throttle parameter to avoid unintended repetition during recalculation.
Related
- Reference: Browse All U Functions