Hello
I have been given this VBA to change the colour of a cell if the value of the cell is changed. It works well.
Private Sub Worksheet_Change(ByVal Target As Range)
Target.Interior.ColorIndex = 5
End Sub
My question; is there a way to change the cell colour back to the original colour, if the cell value is returned to the original value?
Thank you for your help.
Craig
I have been given this VBA to change the colour of a cell if the value of the cell is changed. It works well.
Private Sub Worksheet_Change(ByVal Target As Range)
Target.Interior.ColorIndex = 5
End Sub
My question; is there a way to change the cell colour back to the original colour, if the cell value is returned to the original value?
Thank you for your help.
Craig