How can i change the text color in a cell automaticly if i write.

[copernic]

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.

[Bob Phillips]

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" <[email protected]> wrote in message
news:[email protected]...
> 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.