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.

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

If your subtotaling rows are lost in a sea of worksheet data, use this simple conditional formatting technique to make those rows easy to spot.

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.

Turn raw data into actionable insights with Excel 365’s conditional formatting. Learn to create dynamic visuals with ease in this guide.