Learn how to use a macro in Microsoft Excel to create a new spreadsheet with values and formatting, including the results of conditional formatting. This article provides step-by-step instructions and tips for creating macros in Excel.