You can use macros in Microsoft Excel to automatically perform actions on repetitive tasks. Suppose, you want to compare the measured values with the tolerance values and apply the conditional formatting to the measured value cells. To do this, you can create a macro in Excel and save it in the template file. Excel saves those files as .xlsm files.
To run the macro in the Excel report, follow these steps:
To open the Macro dialog box, press Alt + F8. You can also click the View tab and from the ribbon, in the right-most corner, click Macros and then select View Macros.
From the Macro dialog box, select a macro from the list.
Click Run.