Try this worksheet event macro:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.EnableEvents = False
Range("A1").Copy
Range("B9").PasteSpecial Paste:=xlPasteFormats
Target.Select
Application.EnableEvents = True
End Sub

It links the formatting of B9 to A1. Whenever you change the format of A1,
the format of B9 will automatically change to follow it.
--
Gary''s Student - gsnu200771


"juni" wrote:

is it possible to link two cells having same value colour wise i.e. if both
of them are having name john is it possible to link them in such a way that
when i change one cell's colour the other one changes itself automatically?