Create a powerful macro

- If you're looking at this worksheet for the first time, … you can imagine it would be really helpful if we knew … which cells had formulas in them. … We can do that pretty quickly. … Make sure you click a single cell first, … and then on the Home tab on the ribbon, off to the right, … Find and Select, choose Formulas, … and all the formula cells are highlighted. … You can imagine too, it would be helpful to remember … where these cells are by applying a background color. … So, on the left side of the Home tab in the Font group, … the Fill Color bucket, click the drop arrow. … Be sure to choose a light color … and you can get a preview here of this, … a light color, so you can see the numbers through it, … perhaps this color here. … Now, if you find that useful, … and you think you'd be using it a lot, … why not make it instantly available by way of either … a keystroke shortcut and/or a new button … up in the quick access toolbar? … What we're going to be doing here is creating a macro …