But cell ranges also might have more complicated borders, mixing solid and broken lines or incorporating several colors. Copy and paste these styles with Excel's Format Painter tool.

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.