in E1, use the formula form of the Conditional Format

=if(A1...,True,False)
The format you require will be set if the result is True
This can be reduced to =(A1=...), but it's still basically an IF()

Steve

On Sat, 09 Dec 2006 20:42:01 -0000, Zsolt Szabó
wrote:

Hi! I have two cells : A1 and E1. If I type any stock symbol into A1, I
like
to change the text color in E1.