how to get cell color as per requirement?

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.

Originally Posted by Special-K

Conditional Formatting
New Rule
Use a formula to determine. . .

=(A1="apples")
format as required

Use Format Painter to copy to other cells.

Thank you, my problem is solved.

use conditional format if you can't then attach file.