Guys, I'm struggling with Conditional formatting in a table generated by PowerQuery. Formatting changes entire row cell color based on text in column H - in addition there's a separate Duplicate value formatting for column D exclusively. So, obviously they intersect with each other and I need to set a priority. Both work individually but I need the duplicate value formatting to have the highest priority.
Once I use the priority-changing buttons and move the Duplicate-value formatting to the 1st position, it works great. However the table is scheduled to refresh automatically and once there are changes to the table, conditional formatting priorities are reset back to the status seen on the screenshot below. Given the refresh function works over VBA, I thought I'll just add some dirty fix for that via VBA and this code would indeed raise the priority as expected:
But then I realized Conditional formatting priority is reset only in case the refresh process does some actual changes to the table (not always the case). Might someone have any bright ideas? VBA fix would be OK in this case too, although I have to imagine that sort of thing should be somehow possible by proper table setup...
Once I use the priority-changing buttons and move the Duplicate-value formatting to the 1st position, it works great. However the table is scheduled to refresh automatically and once there are changes to the table, conditional formatting priorities are reset back to the status seen on the screenshot below. Given the refresh function works over VBA, I thought I'll just add some dirty fix for that via VBA and this code would indeed raise the priority as expected:
VBA Code:
ActiveSheet.Range("myTable[SN]").FormatConditions.Item(4).Priority = 1But then I realized Conditional formatting priority is reset only in case the refresh process does some actual changes to the table (not always the case). Might someone have any bright ideas? VBA fix would be OK in this case too, although I have to imagine that sort of thing should be somehow possible by proper table setup...
