Recording on the macro begins immediately immediately after clicking the Near button. Perform the steps you would like to file and also have the macro execute. You could enter data, format the data, create a chart or graph from the data, include formulas, and other actions. The Format Painter is https://www.customguide.com/google-sheets/conditional-formatting-google-sheets