Forum Discussion
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...
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".
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!
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!
