You are here: All Help Topics > Basic Features > Cells > Conditional Formatting

Conditional Formatting

You can set formatting rules for cells in a document with Conditional Formatting. Cells meeting the specified condition are automatically formatted to the assigned style.

Note: Conditional formatting is not supported in the Knowledge Library. Inserting a Knowledge Library into a document does not carry over the conditional formatting from the library.

Each conditional formatting rule requires a condition , a format , and at least one cell ID .

To create a conditional formatting rule:

  1. Select the cells you want to include in the rule.
  2. From the Document menu, click Conditional Formatting | Add Rule.
  3. The selected cells are displayed in the Applies To pane. Set the condition the cells must meet and the formatting style to apply. Click OK.

The new rule is created and applied to the selected cells.

You can manage existing rules from the Conditional Formatting dialog.

Option Description
Show conditional formatting rules for the selected cells, or for the entire document.
View existing conditional formatting rules for the document. Rules display in order of priority.
Reorder the rule priority. Rules at the top of the list take priority if formatting conflicts exist.


  • If a cell meets the conditions of two or more rules, all formatting changes are applied to the cell with overlapping changes applied based on priority.
  • You can copy the conditional formatting rules from one cell to another using the Copy Formatting option. The target cell's new formatting will be added as a separate rule in the Conditional Formatting Rules dialog, overwriting any existing rules for the cell.
  • Currently, you cannot add new cells to an existing rule. You must delete the existing rule and add it again to include the new cell.

Related Topics