Although Microsoft Excel is a powerful spreadsheet out of the box, macros make it even more useful. You can create and record macros within the app.

You can run a Macro in Excel by clicking the macros command on the Developer tab, using a combination shortcut key, by clicking on a graphic object, etc.

If you are new to macros, check out my dedicated guide below, where I go over the benefits and step-by-step instructions for creating macros in Excel.

Conditional formatting highlights key information in a spreadsheet so it’s easy to see at a glance. This beginner’s guide gets you started using conditional formatting.

Helen Bradley demonstrates Excel formatting tricks that will help you when things don't work as planned. Learn her methods now.

Instead of clicking on multiple buttons to add different Word and Excel formats, record a macro, add it to Quick Access Toolbar & use it to get things done.

How to create conditional formatting rules in Excel Once the custom value formats exist, you can apply them using conditional formatting rules. Right now, the format is set to General.

Thanks to the linked cell property in Microsoft Excel, it's super easy to use the selected value as a condition in a macro or conditional formatting rule.