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

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

Hmmm, you said FONT not cell so try this.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column < 4 Then Exit Sub
Target.Font.ColorIndex = 3 '4
End Sub

Regareds,
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

nice...work greats

thanks howard..



"L. Howard Kittle" wrote:

Hmmm, you said FONT not cell so try this.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column < 4 Then Exit Sub
Target.Font.ColorIndex = 3 '4
End Sub

Regareds,
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


.

Hi I have never worked with excel before in terms of creating functions.So please bare with me.I think i have the similiar problem.I have an excel sheet that is attached to a word document which i use to generate reports and everytime the excel sheet gets updated I want the a specific column to change color if there were any change in it.

Please assist me.