We are using Jira macro to show the filter result in confluence page in tabular format.
Now we want to show the table column content should show conditionally …in jira the status will show…like if its done then in GREEN and if its In progress then in YELLOW.
So here we have a column called Billing Status with Running, started and Done…so if the billing status is Running then it should show in YELLOW, if its started then it should show RED etc…
Hi, I’m with CelesteCS - our Conditions for Confluence app (Cloud and Data Center) does this out of the box. Wrap the table in a Conditional Rules Manager and add one Conditional Rule per color:
- “Element text is one of”
Done; Completed → background green
- “Element text is one of”
In progress; Running → background yellow
- “Element text is one of”
Started; Blocked → background red
Set Applies to [Status] (the column header) and Affected elements Whole row if you want the whole row colored. There is also a ready-made “RAG status” preset, and if the column contains Confluence Status macros, “Element status color is one of” can color rows by the lozenge’s color.
Docs: Conditional Rule macro - CelesteCS