Forum Discussion
Copy Conditional formatting of one table to another
I have a table that has multiple rules. I'd like to copy conditional formatting rules to another table. Is this possible without having to manually define each value?
Yes it is possible.
- Go to transform data and create a conditional column (rename it if you want), then define any one condition.
- Click on the added conditional column that you created (look at the applied steps on the right side) and select all "Ctrl+A" and copy the whole query from the top which starts from =Table.AddColumn.
- Now, click on the new conditional column that you created in step 1 and replace the whole query using "ctrl+A" and then "ctrl+V"