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

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.

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

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.