VBA code did not work when conditionally coloured cell

[Jagat Pavasia]

dear sir/madam,
i have a VBA code work well when I manually change the cell colour format .
but my source cell is conditionally changed colour then my below VBA did not work.
please help me

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Worksheets("Sheet1").Range("A2").Interior.Color = Worksheets("Sheet3").Range("C6").Interior.Color
    Worksheets("Sheet1").Range("A5").Interior.Color = Worksheets("Sheet3").Range("C7").Interior.Color
End Sub

 

[Anthony47]

Try using DisplayFormat.Interior, such as

Worksheets("Sheet1").Range("A2").Interior.Color = Worksheets("Sheet3").Range("C6").DisplayFormat.Interior.Color

(Office 2010 and newer)