• Formatting
  • About Cell Formatting
  • Conditional Formatting
  • Adjusting Cell Height
  • Adjusting Cell Width
  • Aligning a Column of Cells
  • Aligning Numbers and Text in a Cell
  • Capitalizing Cell Contents
  • Changing a Cell's Font
  • Changing a Cell's Type
  • Changing The Separator for Date Cells
  • Creating a User Defined Underline
  • Defining Cell Options Globally
  • Distributing Cell Contents Evenly
  • Formatting The Appearance of Negative Values
  • Formatting The Appearance of Positive Values
  • Formatting The Appearance of Zero Values
  • Printing a Currency Sign Inside a Cell
  • Separating Large Currency Values with a Comma
  • Shading a Cell
  • Shading a Column of Cells in Form Mode
  • Shading Multiple Cells
  • Underlining a Cell
  • Underlining The Currency Symbol

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.

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. If required, you can add or remove cells from the rule after creation.

To add/remove cells from a conditional formatting rule:

1. On the ribbon, click Document | Conditional Formatting | Manage Rules.
2. From the rule list, select the rule you want to modify, then click Edit Rule.

3. In the Edit Formatting Rule dialog, next to the Applies To group, click + to add a cell.

   Note: Alternatively, select an existing cell from the Applies To list, then click - to remove it.

4. Navigate to the cell in your document where you want to apply the rule, then double-click it.

The cell is added to the rule. If required, click + again to add another cell.

Manage Existing Rules

You can modify existing conditional formatting rules by clicking Document | Conditional Formatting | Manage Rules.

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.