Conditional Formatting For Confluence Tables with Multiple Header Rows

[majd makhoul]

Hi,

I have the table below with two header rows, and I want to color the table cells based on their values:

• Green for Pass or 0
• Grey for NULL or -
• Red Otherwise

How do I do that? I tried using SQL query but it looks like SQL doesn't support tables with multiple header rows so I'm not sure how to do this. If I write:

SELECT T1.'Column0' from T1

It will print the table and completely ignore Column1 like below:

I'd appreciate any advice!

Thanks

[Katerina Rudkovskaya [Stiltsoft]]

Hi @majd makhoul,

The Table Transformer macro considers your source table as a basic SQL database, so multiple-row headers are transformed into long one-row headers. Please see the example below:

SELECT * FROM T*



As you can see, you can’t refer to your column as “T1.Column 0”, now you have two columns “T1.Column 0 Column 1” and “T1.Column 0 Column 2”. These options will be given to you in the autocomplete (when you type in “T1.” and wait for the hints). I guess that you typed in “T1.Column 0” manually that is not correct.

If you don’t want long headers and need to use multiple-row headers, you may use the Table Spreadsheet macro. It has all the basic Excel functionality (and conditional formatting as well).