Hello,

I'm currently using the following in a spreadsheet to flag data that is
changed in any cell.

Private Sub Worksheet_Change(ByVal Target As Range)
Target.Cells.Font.ColorIndex = 3 'ColorIndex = 3 = Red
End Sub

I would like to change this to only become active if a cell already has data
in it, prior to editing. I assume this would require a VLOOKUP expression but
I cannot figure out how to write it. Any assistance would be appreciated.

Thank you.