ConditionalText

ConditionalText retrieves the defined conditional text results defined for a row, column or cell as part of a conditional format/text definition.

The row and column arguments apply to the intersection in a grid that contains the linked text or note.

Syntax:

ConditionalText("Grid", Row, Column)

Note:

See Parameters for Text Functions for parameter definitions.

If a row parameter is not included, the cell text for all rows will be returned. If a column parameter is not included, the cell text for all columns will be returned. If both the row and column parameters are not included, the cell text for all cells in the grid will be returned.

Example:

Display the text results of a Conditional Text defined for the cell that is in row 21, column B of a grid.

ConditionalText("mygrid",21,B)