Colour cells based on colour of another cell

Hello,

In cell AB2 on Sheet2 I will have some data, which will change based on the data imported into the spreadsheet. This cell will be a particular colour, i.e. green fill with white font.

On Sheet 6 I have a number of cells - namely C29, AD27 & BA26-BA33, which are to be coloured the same as AB2 on Sheet 2.

Is there a way that I could get these cells in Sheet6 to "take on" the colours from AB2 in Sheet, potentially when pressing a commandbutton?


Any help appreciated.

Colours are manually set. So the cells in column AD2 will already be coloured manually.

Please Login or Register  to view this content.

As shown in the attached document (all data removed for testing purpose)

On Sheet2 the cells in AD on Sheet2 are green with red font.

On Sheet6 there are cells that are orange with white font. I am looking for a code to copy the font from AD2 on Sheet 2 to these cells in Sheet6.

Your code was perfect! Thank you very much!

If you want to use the tab name rather than code name:

Please Login or Register  to view this content.

According to the attachment as a very beginner starter just using the Macro Recorder :

PHP Code: 

Sub Macro1()
    [Sheet2!AD2].Copy
    [Sheet6!C29,AD27,BA26:BA33].PasteSpecial xlPasteFormats
    Application.CutCopyMode = False
End Sub 


Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !