nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Is it possible to color a table row based on the value of a column

Alexander Stoyanov

I have a table that is build from data coming from an outside source. I want each row to be colored in a color that is comming from a column named Color, which contains RGB value of a color.

Is this possible?

Accepted answers

Katerina Kovriga {Stiltsoft}

Hi @Alexander Stoyanov ,

You may try the Table Filter and Charts for Confluence app.

Wrap you table in the Table Transformer macro and apply conditional formatting with the help of the Wiki markup:

Fri 1-1.png

Type in your custom SQL query:

Fri 1-2.png

SELECT
FORMATWIKI("{cell:bgColor=" +
CASE WHEN T1.'Color' LIKE "(122,28,134)" THEN "#7a1c86"
WHEN T1.'Color' LIKE "(10,186,181)" THEN "#0abab5"
ELSE "#ccff00"
END
+ "}" + T1.'Column A' + "{cell}") AS 'Column A with Background',
FORMATWIKI("{cell:bgColor=" +
CASE WHEN T1.'Color' LIKE "(122,28,134)" THEN "#7a1c86"
WHEN T1.'Color' LIKE "(10,186,181)" THEN "#0abab5"
ELSE "#ccff00"
END
+ "}" + T1.'Column B' + "{cell}") AS 'Column B with Background',
FORMATWIKI("{cell:bgColor=" +
CASE WHEN T1.'Color' LIKE "(122,28,134)" THEN "#7a1c86"
WHEN T1.'Color' LIKE "(10,186,181)" THEN "#0abab5"
ELSE "#ccff00"
END
+ "}" + T1.'Color' + "{cell}") AS 'Color with Background'
FROM T*

And preview the result:

Fri 1-3.png

And what concerns uploading your source table from the external source, the app also provides the Table from CSV and Table from JSON macros that support outputting data from a URL or an attached file.

All comments

Katerina Kovriga {Stiltsoft}

Hi @Alexander Stoyanov ,

You may try the Table Filter and Charts for Confluence app.

Wrap you table in the Table Transformer macro and apply conditional formatting with the help of the Wiki markup:

Fri 1-1.png

Type in your custom SQL query:

Fri 1-2.png

And preview the result:

Fri 1-3.png

Alexander Stoyanov

Thanks for the replay @Katerina Kovriga _Stiltsoft_ . It looks very promising and I was not aware of the table transformer macro. When I paste your code with the sample table you have provided I get

TypeError: alasql.fn.FORMATWIKI is not a function

Where is FORMATWIKI defined?

Dom_thxc7k

I get TypeError: alasql.fn.FORMATWIKI is not a function as well.

Katerina Kovriga {Stiltsoft}

@Alexander Stoyanov , @Dom , please, check if the version of the Table Filter and Charts for Confluence app is 6.1.0 or newer.

Here is our documentation about cells formatting with the Table Transformer macro. You'll find a lot of use cases there.

If the version of the app is up-to-date but you still can't reproduce our examples, please, raise a support ticket (specify the version of the app and attach your screenshots, we'll investigate the issue).

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server

filter

atl-gruland

table

table-filter

table-filter-and-charts

table-transformer

table-spreadsheet

table-filter-charts-spreadsheets

spreadsheet