actually some actions can be undone after using the vba. but for what I requested meaning to highlight and edit the formatting of the cell or editing the content of the cell itself are irreversible with Undo.
You can try this:
But it will remove all cells interior color except for the active cell.
The active cell will have a interior color of Green.
This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'Modified 3/9/2019 6:47:30 PM EST
ActiveSheet.UsedRange.Interior.ColorIndex = xlNone
Selection.Interior.ColorIndex = 4