Create a new conditional formatting rule As you can see from the list above, Excel offers a quick and convenient way to add conditional formatting to your spreadsheets.

You can add Form Controls items to your worksheets to introduce click-and-drag functionality. An option button, for example, can run a macro when the spreadsheet user clicks it.