See all How-To Articles

How to Copy the Cell Color in Excel & Google Sheets

In this tutorial, you will learn how to copy the color of a cell in Excel and Google Sheets.

 

copy cell color 5

 

Copy the Color With the Format Painter

1. To copy the cell color, select the cell with the color. Then in the Ribbon, go to Home, and choose Format Painter.

 

copy cell color 1

 

2. Then, select the cell where you want to copy the color.

 

copy cell color 2

 

As a result, the cell color will be pasted.

 

copy cell color 3

 

To use Format Painter within a macro, see VBA – Format Painter.

Copy the Cell Color – Paste Special

1. To do this, right-click on the cell with the color you want to copy and from the drop-down menu, choose Copy (or use CTRL + C shortcut).

 

copy cell color 8

 

2. Then, select the cell where you want to paste the color, right-click on it and from the drop-down menu, choose Paste Special.

 

copy cell color 9

 

3. The Paste Special window will appear. Under the Paste section, click on Formats, and after that click on the OK button to finish.

 

copy cell color 10

 

As a result of the previous steps, the cell color will be pasted.

 

copy cell color 11

 

Note: Using this method, it is not possible to copy only the color. All formats of the cell will be pasted (color of text, font, color, bolding, etc.). Therefore, if you want to copy only a color, you shouldn’t have any other formatting in that cell apart from the color.

 

copy cell color 12

 

Copy the Cell Color in Google Sheets

 

copy cell color 17

 

1. To copy the cell color, select the cell with the color, right-click on it and from the drop-down menu, choose Copy (or use CTRL + C shortcut).

 

copy cell color 14

 

2. After that, right-click on the cell where you want to paste the color. In the drop-down menu, click on Paste special, then choose Paste format only.

 

copy cell color 15

 

As a result of the previous steps, the cell color will be pasted.

 

copy cell color 16