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

[Stiltsoft support · Accepted solution]

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 @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.

[Cyrille Martin · Accepted solution]

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

[Stefan Höhenleiter]

Hey @Cyrille Martin,

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

Best regards