Conditional formatting

Conditional formatting colours a math result when a rule matches — for example a utilisation above 1.0. It does not change the number. Rules live on that region; they are not a sheet-wide style.

Open the dialog

1. Right-click a math region and choose Edit conditional formatting….
2. Tick Enable conditional formatting.
3. Choose Add rule for each condition.
4. Choose Apply to save, or Cancel / Escape to discard.

The dialog title is Conditional formatting. Help text on the dialog: rules apply to numeric scalar results only. The first matching rule (top to bottom) wins — use the arrows to reorder. Background is none unless you enable Tint background.

Clicking outside the dialog does not close it. Use Cancel, the ×, or Escape.

A rule

Each rule has:

• Condition — ≥ greater or equal, > greater than, ≤ less or equal, < less than, = equal, ≠ not equal.
• Compare against — Fixed value (type a number) or Variable (another name already on the sheet, not this region’s own assignment).
• Tint background — off by default. Turn it on, then pick Tint colour.
• Text colour — always available.
• Bold, Italic, Underlined.

Use the ↑ / ↓ buttons to reorder. ✕ removes that rule. Copy the region and the rules come with it.

Enable or disable without deleting

After you have saved rules, the same context menu shows Disable conditional formatting or Enable conditional formatting so you can turn the rules off without deleting them. Edit… still opens the full dialog.

Summary tables that link to this name pick up the same colours — see Summary tables.