Formatting Cells
After a rule is set up, use the Process Cell dialog box to set how cells display in forms.
To format cells:
- In the Data Validation Rule Builder dialog box, click
in the right-most column.Note:
If the 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, and Then conditions. The icon isn't displayed until all required columns are selected for a rule. See Creating and Updating Data Validation Rules.
- 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 these options: a cell background color or a validation message.
-
To add or update the cell background color, click
. To remove the cell background color, click 
.
-
To display a validation message for the cell, enter the message in the Validation 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 Display message in the Data Validation Messages pane check box is selected. For information on viewing and resolving data validation errors, see Working with FreeForm.
-