Format Rules
2 answers
Hi @Chloe Dsouza,
It depends on where you want the formatting to apply. You can't add it to the issue search/Filters results, so a JQL search on its own won't let you color rows. Native conditional formatting only exists in the project List view, and only on projects that have that feature.
Where you do have the List view, Jira calls this format rules. You can automatically color a single cell or a whole row when a condition is met (for example, a red row when the due date is in the past, or a yellow cell when there's no assignee). Open your List, find the format rules option in the list toolbar, add a rule, pick the field and condition, then choose the color. The fields you can use depend on the columns you've added, and the rules don't carry over to board cards or views that span multiple projects.
If you need conditional formatting on a broader filtered list (across projects, or with more rule types) and you're open to an app from the Atlassian Marketplace, JXL for Jira can do that. It's a spreadsheet-style view where you set ordered conditional formatting rules on text, number, date, or status conditions and color cells or whole rows.
Disclosure: I work on the team that builds JXL.
Hope that helps,
Martin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.