Change Font colour in cells?

[Zoe79]

In each cell of column A I have individual names in red font, I want the names to turn black when I enter dates in the individual cells in column R, is this possible?

 

[RichardMGreen]

Try conditional formatting for the cells in column A.
You'll need to use a formula along the lines of :=
=r1<>""
and then copy the formatting down.

You'll also need to set the format to use (i.e. black text) for when the condition is true.

 

[VoG]

Try this: right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 18 Then Target.Offset(, -17).Font.ColorIndex = xlAutomatic
End Sub

 

[anandvarma]

try this formula

Excel Workbook
	A	B
19	asdf
20	wqer	26/05/2010
21	qer
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A20	1. / Formula is =B$20=(TEXT(B$20,"dd/mm/yyyy"))+0	Abc