Hi, I am new member of this forum. This is my first thread. My question is mentioned below.

I want to be able to change a color of one cell according to color of another cell. suppose, cell A1 has text "apples" having red color. Now, if I enter text same as A1("apples") in another cell, say B1, then color of text entered in cell B1 should be red.
I am using Excel 2007

How can it be done?
Please, answer this question.
Thanks in advance.