Use conditional formatting.

Add formula conditions of

=L25=""

and set the colour to black. Add another condition of

=L2<""

and set the colour to red.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"copernic" wrote in message
...
How can i change the color of a text in a cell automaticly if i write a
text
in another cell.
Exampel: in cell C13 i have the text P2 in the color black. If ´the cell
L25
is blank the text in cell C13 chould be black. If i type a text in cell
L25
the text schould turn red.