Conditional Formatting

Conditional Formatting allows you to visually highlight issues in the Excel-like Issue Bulk Editor via Field-based or JQL-based conditional formatting. This helps teams quickly identify important issues, such as overdue tasks, blockers, or high-priority items.

Field-based

You can define simple rules based on field values.

When an issue’s field matches the defined condition, the selected style will be applied.

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 → Field-based.

2. From the Field name drop-down list, select the field you want to base the condition on.

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

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

5. Click the “+” button to add the rule.

6. Set the Highlight Color for the background.

7. After defining one or more rules, click Apply to save and activate the conditional formatting.

JQL-based

For more complex conditions, you can now define formatting rules based on JQL (Jira Query Language) expressions.

Formatting will automatically apply to all issues that match the given JQL query.

Example use cases:

• Highlight overdue issues:

  NONE

  duedate < now()

• Highlight active high-priority issues:

  NONE

  statusCategory != Done AND priority = Highest

• Highlight team-specific issues:

  NONE

  component = "Backend" AND status = "Blocked"

Configuration Steps:

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

2. Enter a valid JQL query.

3. Click the “+” button to add the rule.

4. Set the Highlight Color for the background.

5. After defining one or more rules, click Apply to save and activate the conditional formatting.