How to Copy Conditional Formatting Color to Another Cell in Excel: 3 Methods

Method 1 – Using Paste Special Option

Steps:

Color cell C5 using the Conditional Formatting option.

Note: We highlighted the cells with values greater than 80.

Using Paste Special Option to copy conditional formatting color to another cell in Excel

Select cell C5 and use the keyboard shortcut CTRL + C to copy the cell.

- Choose the range of the cells you want to copy the Conditional Formatting color. In this case, we have selected the range C5:F12.
- Go to the Home tab from Ribbon.
- Select the Paste option from the Clipboard group.
- Choose the Paste Special option from the drop-down.

Select the Formats option in the Paste Special dialogue box, as shown in the following image.
Click OK.

The conditional formatting color of cell C5 will be copied to the range of cells C5:F12.

Final output of method 1 to copy conditional formatting color to another cell in Excel

Method 2 – Utilizing Format Painter

Steps:

Follow the previously mentioned steps to color cell C5 using the Conditional Formatting option.

Utilizing Format Painter to copy conditional formatting color to another cell in Excel

Select cell C5 and go to the Home tab from Ribbon.
Choose the Format Painter option from the Clipboard group.

Select the range of the cells you want to apply the copied conditional formatting color of cell C5. We selected the range of cells C5:F12.

The conditional formatting color of cell C5 will be copied to your selected range, as demonstrated in the following picture.

Final output of method 2 to copy conditional formatting color to another cell in Excel

Method 3 – Using Conditional Formatting Rules Manager

Steps:

Follow the steps mentioned in the 2nd method to copy the conditional formatting color of cell C5 to the range of cells C5:C12.

Using Conditional Formatting Rules Manager to copy conditional formatting color to another cell in Excel

Select any cell of the History column. In this case, we chose cell C11.
Go to the Home tab from Ribbon.
Select the Conditional Formatting option from the Styles group.
Choose the Manage Rules option from the drop-down.

The Conditional Formatting Rules Manager dialogue box will open on your worksheet.

Select the Rule in the Conditional Formatting Rules Manager dialogue box.
Click on the Duplicate Rule option.

Click the marked area on the duplicated rule and select the range of cells D5:F12.
Click on Apply.
Click OK.

The conditional formatting color of the History column will be copied to the range of cells D5:F12, as shown in the image below.

Final output of method 3 to copy conditional formatting color to another cell in Excel

How to Copy Conditional Formatting to Another Sheet in Excel

Steps:

Select cell C5 from the Duplicate Rule worksheet and go to the Home tab from Ribbon.
Click on the Format Painter option from the Clipboard group.

How to Copy Conditional Formatting to Another Sheet in Excel

Go to the worksheet where you want to copy the conditional formatting color of cell C5 of the worksheet named Duplicate Rule.
Select the range of cells C5:F12 in the worksheet where you want to copy the conditional formatting color.

You will have the conditional formatting color copied to another worksheet as demonstrated in the following picture.

Final output of method 4 to copy conditional formatting color to another cell in Excel

How to Copy Conditional Formatting to Another Workbook in Excel

Steps:

Use the steps mentioned in the previous method to copy conditional formatting in another workbook.

Note: The only difference from the previous method is that we must copy the conditional formatting to a new workbook instead of a new worksheet. The rest of the procedure is the same.

How to Copy Conditional Formatting to Another Workbook in Excel