I created a conditional formatting that highlights the top 20% and the bottom 20% of data in a given column, but when i try to use the clone formatting tool on another column, it starts highlighting the top and bottom 20% based on the data from both columns, instead of treating each column separately.
This is expected if you include them in the same range.
Make separate rules if you want them evaluated separately.