Format condition

[leakhna]

Hi,

I have an excel sheet which is share with everyone in my team and all of them update data different day and some data has been modify. I'm manage master file and it is very difficult for me to check what is the new update and what has been modify unless i compare two file together.

I wish we could have a formular to set up a highlight color for new update and on modify.( imean if the data update today it should pop up with green color, if modify could be with yellow.

I asked my team manually highlight but sometime they forgot.

Thanks and waiting for reply.

Leakhna

[FDibbins]

Perhaps use Conditional Formatting, based on TODAY()

[kvsrinivasamurthy]

See file Attached
Worksheet Events are used. Range B1:E6 is used. Can be changed.
code

Dim PreValue As Variant
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Not Intersect(Target, Range("B1:C6")) Is Nothing And Target.Cells.Count = 1 Then
PreValue = Target.Value
End If

End Sub
Private Sub Worksheet_Change(ByVal Target As Range)

If Not Intersect(Target, Range("B1:E6")) Is Nothing And Target.Cells.Count = 1 Then
    If PreValue = "" Then
    
    With Target.Interior
        .Pattern = xlSolid
        .PatternColorIndex = xlAutomatic
        .ThemeColor = xlThemeColorAccent3
        .Color = 65535
        .TintAndShade = 0
    End With
    
    ElseIf PreValue <> Target.Value And Target.Value <> "" Then
    
    With Target.Interior
        .Pattern = xlSolid
        .PatternColorIndex = xlAutomatic
        .ThemeColor = xlThemeColorAccent3
        .TintAndShade = 0.599993896298105
        .PatternTintAndShade = 0
    End With

    End If

End If

End Sub