Formatting Cells

After a rule is set up, use the Process Cell dialog box to set how cells display in forms.

To format cells:

  1. In the Format/Data Validation Rule Builder dialog box, click Process Cell icon (Process Cell) in the right-most column.

    Note:

    If the Process Cell icon isn't displayed, ensure that the rule is valid and that it permits cell processing instructions. For example, cell processing instructions are included for Else, Range, Then, and Format conditions. The icon isn't displayed until all required columns are selected for a rule. See Creating and Updating Data Validation Rules in Forms.

  2. In the Process Cell dialog box, set how the cell should appear in forms if the conditions defined by this rule are fulfilled.

    When the rule is enabled, it doesn't validate unless you specify at least one of the formatting options or a validation message.

    • To add formatting options, click options in Format Cell for Font and Alignment and Border and Shading. As format options are selected, the Current Format displays how it would appear when displayed on the form.

    • To display a validation message for the cell, enter the message in the Message field. Users see this text when they select Show Data Validation Messages in the context menu that appears when you hover over the cell in the form. It also appears as a link in the Data Validation Messages pane if data cells are flagged by the validation rules and the Show in Format/Validation Messages pane check box is selected. For information on viewing and resolving data validation errors, see Working with FreeForm.

  3. Click OK.

    Updates for the rule are displayed in the Process column for the rule. If you specified formatting, that formatting is displayed. You can preview a validation message by hovering the cursor over the Process column.