Right click on sheet tab

Paste this code

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Column = 8 And Target.Column <= 12 Then
CurR = Target.Row
Range("F" & CurR).Value = Now
End If

End Sub

For Coloring use the conditional formatting

to color Green - use this
=TODAY()-INT(F2)<=3

to color Yellow - use this
=AND((TODAY()-INT(F2))3,(TODAY()-INT(F2))<=5)

to color Red - use this
=TODAY()-INT(F2)7

What about if the last updated in last 6 days ?


On Nov 16, 5:01*pm, BakerInSpain
wrote:
I am looking for a solution.

My spreadsheet has 5 columns that i do not want this to affect. The 6th
column is "Last Updated".

When i write comments in any cell after H i want it to put the updated date
and time into "Last Updated" in that row.

Another addition to this would be to check the last updated date, if it is
upto 3days from today then turn green, upto 5days yellow and more than 7days
red!

I hope someone can help!