Table Transformer - condition on any cell value

[Kristian Bohm]

Hi,

I have a table with many columns.  I'd like to conditionally format ALL of these based on a cell value.

Crappy pseudo code...

Rather than:

SELECT
CASE
WHEN T1.'col1'="Yes" THEN blart

END AS 'col1'

CASE
WHEN T1.'col2'="Yes" THEN blart

END AS 'col2'

CASE
WHEN T1.'col3'="Yes" THEN blart

END AS 'col3'

...

CASE
WHEN T1.'col22'="Yes" THEN blart

END AS 'col22'

I'd rather do this:

SELECT
CASE
WHEN T1.* ="Yes" THEN blart

END AS *

[Stiltsoft support]

Hi @Kristian Bohm ,

Maybe the Table Spreadsheet macro will suit you better? It provides the Excel-like conditional formatting as well.

And if you already have a big native table with multiple columns created or your source table comes from the Page Properties Report macro, you may use the Spreadsheet from Table macro to turn your existing table in a spreadsheet and then apply the Excel-like conditional formatting.

[Kristian Bohm]

Thank you.  I will try this out and let you know.

[Kristian Bohm]

I'm not sure this will work for my case.  For my case (which I did not mention) I want to merge multiple tables using Transformer.

Else; I do think the Table Spreadsheet would work.

[Stiltsoft support]

Then you may merge your tables with the help of the Table Transformer macro (just merge and not color) and wrap this Table Transformer macro in the Spreadsheet from Table macro. Your merged table will be turned into a spreadsheet where you will be able to apply conditional formatting.

[Kristian Bohm]

I saw the 'Spreadsheet from Table' macro when investigating your suggestion but it's disabled on our system.