using VB to link formats

[Sarah-Jane]

as well as linking the data from one cell to another I also am trying to link the format of one cell to another so that when I change the fill colour of font of the first it automatically changed the second.

[Bryan Hessey]

as well as linking the data from one cell to another I also am trying to link the format of one cell to another so that when I change the fill colour of font of the first it automatically changed the second.

A variation of:

Range("A2").Interior.ColorIndex = Range("A1").Interior.ColorIndex

should do it

You can also change Font details that way, record a macro to get the seeting required and amend for your ranges.
---