Method for Excel 2019 The following method works for Excel versions 2013 through 2019. Click the cell containing the conditional format you want to copy.

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.

Formatting data in your spreadsheet is a great way to make it stand out. With conditional formatting, you can take it a step ...

Formulaic conditional formatting rules in Microsoft Excel can be tricky, so learn how to avoid a common mistake.

Click the upper-left cell in the range with the border you want to copy. Drag your cursor to the range's lower-right cell, selecting the entire range. Click "Home" on Excel's menu bar.