Highlight changes if orginial cell value has changed

[max P.]

hi, i have the vba below who alow me to hightlight changes if the orginial cell value has changed. the problem is that it's stay highlight week after week and the goal is to know if there was a change last week. So the ideal is to insert a vba that would say hightlight if the cell value has changed between 7 days ago and today. what changes do I need to do?
p.s: i work with excel 2010 thanks

Private Sub Worksheet_Change(ByVal Target As Range)
Const WS_RANGE As String = "F10:F309"

On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then
With Target
.Interior.ColorIndex = 6
End With
End If

ws_exit:
Application.EnableEvents = True
End Sub

[Charles]

Hi,

Welcome to the forum.
Please read the rule about using code tags when you are posting a message. Aside from that how would you determine if something has changed with in the range that you specified?
Could you attach a copy of your workbook with a before and after example?

[max P.]

i would determine if something has changed if the cell valu is different. example, a cell have a date 2011-04-11 and right after someone change it for 2011-04-15 the cell would turn highlight yellow.

sorry but i'm not sure what you want me to copy before and after.

thanks

[jwright650]

sorry but i'm not sure what you want me to copy before and after.

thanks

Charles is speaking of Forum Rule #3

[max P.]

Please Login or Register  to view this content.

here is the code that i have copyed in my workbook

[Charles]

Max P


Try the following code in your sheet code module.

Please Login or Register  to view this content.

Please Login or Register  to view this content.