Changes after a specific date.

[jyokom]

I am trying to have cells display red for information that was typed after a certain date. I know that is easy except that I don't wan't the information that already exhists in the cells to be formatted differently, only changes after the date.

Any suggestions?

 

[brian.wethington]

Assuming you don't have the Format conditions in place yet.

Sub CF()

With Range("A3:B4").
    FormatConditions.Add Type:xlExpression, Formula1:="=And($A$1,A3<>A10)"
    .FormatConditions(1).Font.ColorIndex = 3
    .Copy
    Range("A10").PasteSpecial xlFormats
End With

End Sub

You may have to play around with your CF expression as I am unsure how you are making your determinations.

Finally I am not sure what you mean by:

How do you keep A1 as a constant? I know that you could define a string and assign it the value of A1, but how would you add that in the format?

Your code created the constant in A1.. is that not how you wanted it to work?