Text Colour In Linked Cell

[[email protected]]

Is there any way to carry the formatting of a cell to a linked cell,
particularly the font colour so that if the font colour is changed in
the parent cell the font colour will change in the linked cell?

Any help is appreciated.

[CaptainQuattro]

Use conditional formatting to determine the text colour of both cells

Example:

Click on Cell A2 and choose Formatting > Conditional Formatting

Condition 1

Formula is =$a$1=1

Click the Format button.
Choose a Color and OK.

Click Add>>

Condition 2

Forula is =$a$1=2

Click the Format button
Choose a second color and OK

Now when you enter 1 into cell A1, text in cell A2 will change to your first color, enter 2 in cell A1 - your second color appears. Enter anything else in cell A1
the text in Cell A2 reverts to black .

To make a second cell change colour in unison with cell A2, copy cell A2 and Paste Special > Formats.