Hi,
There seem to be some problem with splitting/changing conditional formatting cells range only if performing Cells.copyColumns,
I couldn’t attach XSLX file (please let me know how if there is such an option).
But i…... But copyColumn splits replaces existing single rule with...formatting. The rule changes the color from very light to very dark...