Calling the color of the text from another cell

[pglufkin]

I have a cell of text with a certain color which i have named 'text'. In another cell I am trying to call that cell (+text). How can i have '+text' be the same color as 'text'? Thank you.

[Fotis1991]

Hi

If A1= cell, that you Named it "TEXT".

B1= The cell that you try to have the same color.

Then in Conditional Formatting of B1, put the formula. =A1="TEXT"

Choose your color.>>OK.

Hope to helps you.

[pglufkin]

Hi, thank you for your response.

This not actually the case what you described.

Let me describe it in another way. lets say in cell C1 i have some wording . . . . it says 'ball'. The word ball has the font color of red.

In cell A1, i want to refer to C1 so that cell A1 also says 'ball' in red. If i change the color of 'ball' in C1 to blue, i also want cell A1 to turn blue. If i change the wording in cell C1 to 'base', i also want the cell in A1 to also say 'base'.

Hopefully that is a little clearer.

[Fotis1991]

Hi

If you have few words that you need to change color, then you can do it, using Conditional Formatting, or else i think you need VBA and in this case i can not help you.

For few words you have to use same Conditional Formatting for A1 & C1.

Something like this in both cells(In Conditional Formatting options).

=$C$1="ball" >>>>Color red>>>OK

=$C$1="base" >>>>Color blue>>>OK

e.t.c...