change color font after updated
You could try something like this. Might get you headed in the right
direction.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column < 4 Then Exit Sub
Target.Interior.ColorIndex = 4
End Sub
HTH
Regards,
Howard
"reza" wrote in message
...
hi all,
i work with excel everyday, sometimes i forget which one i already changed
in that sheet.
i.e in column D, i have a values.
now every time i changes or update that column, the color of font will
change automatically maybe red, yellow or anything. at least i can know
the
changed.
many thanks for ur help
reza
|