Highlight the entire contents of an Excel report modification

If you can modify the Excel report to highlight the full contents of the changes, the modification work at a glance, will increase the efficiency.

After research, I found a way: To start Excel, click the "tools" → "macro" → "security" (such as the figure), in the "Security level" select ", you can choose whether to run potentially unsafe macros."

Then open the Excel report that you want to modify, right-click the sheet tab, select View Code, and attach the relevant code to the Code box on the right.

Code fragment: Private Sub Worksheet_change (ByVal Target as Range) Target.Font.Color = vbred End Sub

Finally, click "File" → "Close and return to Microsoft Excel", Save and exit. To reopen the file, a Security Warning window will appear, and click "Start Macro".