Reference
No results for 'undefined'
    Powered by Algolia

    COPY_STYLE_IF

    Applies styles from a particular cell to the range.

    Syntax

    =COPY_STYLE_IF(logical_expression, [cell_ref_if_true], [cell_ref_if_false], to_range)

    Parameters

    1. logical_expression
      • Type: Boolean
      • Description: An expression or reference to a cell containing an expression that represents some logical value, i.e. TRUE or FALSE.
    2. cell_ref_if_true [optional]
      • Type: Frame
      • Description: The cell whose styles will be applied if expression is TRUE
    3. cell_ref_if_false [optional]
      • Type: Frame
      • Description: The cell whose styles will be applied if expression is FALSE
    4. to_range
      • Type: Range
      • Description: The range in which styles will be applied

    Features

    • Modifies spreadsheet.

    Returns

    • Type: Boolean
    • Description: Returns boolean value

    Example

    =COPY_STYLE_IF(A2 > 5, B3, C4, D12:H21)

    Try It Now

    Sorry, your browser is not supported. MINTDATA™ works best on Google Chrome 50.0+ and Firefox 44.0+.
    Contents