End-User Capabilities: Conditional Formatting

• Jun 30, 2023

End users can use Conditional Formatting to highlight cells or rows based on a specific condition. Cells and rows can be highlighted using animated data bars, icons, and predefined color scales.

Do the following to apply a format condition to column cells:

1. Right-click within a column header or data cell to display a context menu.
2. Click the Conditional Formatting menu item and select a rule.

Note

Enable the OptionsMenu.ShowConditionalFormattingItem option to display the Conditional Formatting item within the context menu.

Create Custom Rules

Click the Manage Rules… menu item to display the manager of conditional formatting rules. The manager allows you to create custom rules.

1. Click the New Rule… button.
2. Select the Use a formula to determine which cells to format rule type.
3. Specify a custom condition.
4. Click Format to specify appearance settings that should be applied to cells whose values match the condition.
5. Click OK to save a custom rule.

See Also

Appearance and Conditional Formatting