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
Thanks