Prev: update workbook links over network
Next: in MS EXCLE how we can protect only one cell?
From: reza on 24 May 2010 06:14
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
From: L. Howard Kittle on 24 May 2010 16:39
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" <reza(a)discussions.microsoft.com> wrote in message
news:3AD15AAB-409A-4A5D-A651-411DC101B618(a)microsoft.com...
> 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


From: L. Howard Kittle on 25 May 2010 00:18
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" <reza(a)discussions.microsoft.com> wrote in message
news:3AD15AAB-409A-4A5D-A651-411DC101B618(a)microsoft.com...
> 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


From: reza on 25 May 2010 02:50
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" <reza(a)discussions.microsoft.com> wrote in message
> news:3AD15AAB-409A-4A5D-A651-411DC101B618(a)microsoft.com...
> > 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
>
>
> .
>
 | 
Pages: 1
Prev: update workbook links over network
Next: in MS EXCLE how we can protect only one cell?