You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I have a table with many columns. I'd like to conditionally format ALL of these based on a cell value.
Crappy pseudo code...
WHEN T1.'col1'="Yes" THEN blart
END AS 'col1'
WHEN T1.'col2'="Yes" THEN blart
END AS 'col2'
WHEN T1.'col3'="Yes" THEN blart
END AS 'col3'
WHEN T1.'col22'="Yes" THEN blart
END AS 'col22'
I'd rather do this:
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.
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.