Change the text of the board member’s name to blue.
Highlight the cell containing the board member’s name in yellow.
But, she’s realizing that it’s taking her forever to find the board member at each table and then go through those three different formatting steps for each and every board member cell. With a little Excel knowledge under her belt, she decides to build a simple macro-so, when she finds a cell for a board member, she can apply those three formatting rules with just a single click of a button. Let’s build this macro right along with Sophia. To start, click in a cell that does not belong to a board member, go to the “Developer” tab, and then click “Record Macro.”Īt that point, you’ll see a window that gives you the option to name your macro (important note: Excel will not allow you to include any spaces in your macro name). You can also enter a keyboard shortcut to apply that macro (in Sophia’s case she’ll use option+command+b for board member) and a description (which is helpful if you record and store a lot of macros).Ĭlick to store the macro in that workbook (since that’s where Sophia is working with the data). When you’re done entering the necessary information, hit “OK.” At that point, you’ll see “Stop Recording” in the “Developer” tab. This means that you’re actively recording your next steps.
0 kommentar(er)
