Conditional Formatting

Conditional Formatting lets you highlight issues in the Excel-like Issue Bulk Editor using Basic or JQL-based rules. This helps teams quickly spot important issues like overdue tasks, blockers, or high-priority items.

You can manage conditional formatting rules after they are created. Reorder rules to set their priority or turn individual rules on and off without deleting them.

Basic

Define simple rules based on field values.

When an issue’s field matches the condition, the selected style applies.

Example use cases:

• Highlight issues where Priority = Highest

• Highlight issues where Status = Blocked

• Highlight issues where Assignee = Unassigned

Configuration Steps:

1. Go to Operation Bar → Conditional Formatting → Basic.

2. Select the field to base the condition on from the Field name drop-down list.

3. Choose an Operator (e.g., equals, not equals, contains).

4. Select or enter the Field Value for the condition.

5. Set the Color for the background.

6. Set the Highlight Style for the background.

   1. Highlight Row

   2. Highlight Cell

7. Click the “Create” button to add the rule.

8. After defining rules, click Save Changes to activate the conditional Formatting.

JQL-based

For more complex cases, you can now define formatting rules using JQL (Jira Query Language) expressions.

Formatting applies automatically to all issues matching the JQL query.

Example use cases:

• Highlight overdue issues:

  duedate < now()
  

• Highlight active high-priority issues:

  statusCategory != Done AND priority = Highest
  

• Highlight team-specific issues:

  component = "Backend" AND status = "Blocked"
  

Configuration Steps:

1. Go to Operation Bar → Conditional Formatting → JQL.

2. Enter a valid JQL query.

3. Set the Highlight Color for the background.

4. Click the Create button to add the rule.

5. After defining rules, click Save Changes to save and activate the conditional Formatting.