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.

Applying the same formatting to each sheet in an Excel workbook is ideal when each of your sheets is set up the same, but it can be helpful in other circumstances as well.