Solved: change font color after updated

[mbarron]

The following will change the font color to red in column E after the value has changed.
Right click on the sheet's tab and choose View Code.
Paste the following:
[vba]Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 5 Then
Target.Font.Color = vbRed
End If
End Sub[/vba]