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.


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=529873