Here's the scenario.
If I change the value of a cell, the cell changes color. -- I am using the following code for this:
Is there any way that the cell reverts back to its original formatting when I change it back to its original value?![]()
Private Sub Worksheet_Change(ByVal Target As Range) Target.Interior.ColorIndex = 19 End Sub
Eg.
12345 --> 67890
67890 --> 12345
Bookmarks