Forum Discussion
juanand
Apr 28, 2020Copper Contributor
Conditional Formatting and Power Query
Hi there, I am struggling with Conditional Formatting and Power Query. Short question is ... is there a way to prevent conditional formatting from shifting in a Power Query-based table when addi...
JKPieterse
Apr 28, 2020Silver Contributor
Try if this helps:
Right-click the table in question and choose Table, "External data properties...". Set the table to "Overwrite existing cells with new data, clear unused cells".
Right-click the table in question and choose Table, "External data properties...". Set the table to "Overwrite existing cells with new data, clear unused cells".
- juanandMay 05, 2020Copper Contributor
Thanks, that option did it actually did not solve the problem, but was really close (I guess the intent 🙂 ) !!
It works for my scenario to tick the "Preserve column sort/filter/layout".
That allows moving columns around in Excel itself, respecting the conditional formatting formulas, or hiding columns as needed, instead of touching the PowerQuery results and breaking the column sorting and conditional formatting of resulting data table.
Thanks a lot!
- stevenwm94Aug 20, 2021Copper Contributor
juanand, If I ever met you I would give you a big hug! Have no idea the struggle I've been going through on this issue.
This worked!