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; } } }

conditional formatting in edit mode

Stefan Höhenleiter

Hi everyone,

I'm currently working on adapting an existing meeting template in Confluence. While there's already a native Confluence table in use, we’d like to further optimize it - especially in terms of formatting for easier editing.

At the moment, we're still working in Excel, as it allows us to use conditional formatting to highlight due dates visually. This functionality would also be extremely helpful in Confluence - particularly in the editing mode, since we usually take notes live during meetings. While the Table Transformer macro offers similar functionality, it only applies formatting in the published view, not while editing.

So my question is: does anyone know of a macro, HTML script, or any other method that allows for automatic color highlighting (e.g., based on dates) within the editing view?

If anything is unclear, I’d be happy to clarify or discuss further.

Best regards,
Stefan

Accepted answers

Cyrille Martin

Hi @Stefan Höhenleiter

Natively, you cannot do a conditional formatting in a table.

But with the plugin excellentable spreadsheet for confluence you can do it.

Enjoy

Regards

Stiltsoft support

Hi @Stefan Höhenleiter ,

As you've mentioned the Table Transformer macro, we suppose that you have our Table Filter, Charts & Spreadsheets for Confluence app.

If this is the case, you may take the Table Spreadsheet macro and apply conditional formatting/use it for meeting notes. The macro is editable both from page view and page edit mode.

All comments

Cyrille Martin

Hi @Stefan Höhenleiter

Natively, you cannot do a conditional formatting in a table.

But with the plugin excellentable spreadsheet for confluence you can do it.

Enjoy

Regards

Stiltsoft support

Hi @Stefan Höhenleiter ,

As you've mentioned the Table Transformer macro, we suppose that you have our Table Filter, Charts & Spreadsheets for Confluence app.

If this is the case, you may take the Table Spreadsheet macro and apply conditional formatting/use it for meeting notes. The macro is editable both from page view and page edit mode.

Stefan Höhenleiter

Hey @Cyrille Martin,

thanks for the quick reply. I have tested it and with an additional plugin it works.

Best regards

Stefan Höhenleiter

Hey @Stiltsoft support,

thanks for the good reply. I have already found this solution and it works so far. Now to my other question. We also want to include Jira tasks in this table, this is easily possible in the native table. Is it also possible to link a Jira task within your macros?

Kind regards

Stiltsoft support

Hi @Stefan Höhenleiter ,

You may take the Spreadsheet from Table macro and wrap your Jira Issues macro inside its body. Then you'll see your Jira Issues table turned in the live spreadsheet-like table and you'll be able to work with it in Excel-style.

If you are talking about regular Table Spreadsheet macros, you can insert regular urls to its cells (web addresses, Jira links, and so on - they are treated like common links).

Please refer to our support portal in case of any further questions - it's confidential and we'll be able to discuss your case in details.

Welcome!

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

Quick Links

Find more posts tagged with

confluence

filter

data-center

table

table-filter

table-filter-and-charts

confluence-data-center

table-transformer

table-spreadsheet

table-filter-charts-spreadsheets