If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
change color font after updated
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
change color font after updated
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 |
#4
|
|||
|
|||
change color font after updated
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 . |
Thread Tools | |
Display Modes | |
|
|