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 *
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I saw the 'Spreadsheet from Table' macro when investigating your suggestion but it's disabled on our system.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.