I have this code and it changes the fill color G25 based on the fill color of G25:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Me.Range("g25").Interior.Color = Me.Range("f25").Interior.Color
End Sub
Now how do I change the fill color of F25 in Sheet2 based on the fill color on G25 Sheet1?
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Me.Range("g25").Interior.Color = Me.Range("f25").Interior.Color
End Sub
Now how do I change the fill color of F25 in Sheet2 based on the fill color on G25 Sheet1?