Table Transformer - condition on any cell value

Question

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 *

Kristian Bohm · Answer

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

Stiltsoft support · Answer

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 · Answer

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.