How to copy fill color from conditional formatting to another cell

I would like to copy the display color from a range (A1:D10 for example) that has 3 color scale conditional formatting over to another range (AA1:AD10). The second range (AA1:AD10) has unique values that I don't want to be replaced by the values from the first range (A1:D10). The ranges will be the same size.

Can't you apply the same CF rules to that second range, making appropriate adjustments to the cell references?

Hope this helps.

Pete

Wouldn't that just apply the CF rules to the data in that range?

This example is what I want my worksheet to do: https://www.excelforum.com/excel-gen...ml#post5523886

How can I change this to work to copy multiple columns? ex. Copy the CF from A1:D10 over to AA1:AD10?

So this is what I ended up doing, and it works, but I'm sure there's got to be a cleaner way to enter the ranges. So the range who's conditional formatting colors I wanted to copy was BQ13:CK112, and the range I wanted to copy the color to was C13:W112.

Please Login or Register  to view this content.