Change formatting options in a named range

If you have formatting options configured as a named range and are referencing the named range in a query, you can change the value in one or more cells and apply the changes.

To change a format option for a named range:

1. Select one of the cells in the named range and change the value. For example, change the Italic Heading option from FALSE to TRUE.

2. Select the cell containing the function that refers to the format named range.

3. On the Historian menu, click Refresh Function.

   Note: The Refresh Sheet command refreshes the data values, but not the formatting.

   The new formatting options are applied to the results.