Copy conditional formate colour from a range of cells to another cell range

[Faaiza]

I have used the conditional formatting colour scale on a range of cells (BY11:CV20). I would like to copy the colour format of these cells to another range (AC11:AZ20). I only require the cell background colour to be copied and pasted. My workbook name is Cars and my sheet name is Channels. I am new to VBA and have tried different coding but nothing works. Can someone please help me.

Thanks

 

[mikerickson]

You can copy the cells with the CF and then PasteSpecial Formats to the new cells.

 

[Faaiza]

I only want the background color of the cells to be copied and not the conditional format. I want the new range to mirror the color format of the range wherein the conditional format applied

 

[mikerickson]

Then CF the background color of the new cells to the same conditions as the old cells.

 

[Faaiza]

Apologies maybe I am not explain clearly. The conditional format (color scale) is applied to cells BY11:CV20 (data is cost of purchase). Based on the conditions the cells are colored accordingly. There is a completely different set of data in cells AC11:AZ20 (and I cannot apply the same conditional format as this set is referring to months)). I want the cells in AC11:AZ20 to have the same color format as the cells BY11:CV20

 

[mikerickson]

You can apply Conditional Formatting to look at other cells to determine when to activate.

 

[Faaiza]

I want to past the formatting without the formatting rules. I came across this macro but can't seem to adapt it for my data