See all How-To Articles

How to Copy Cell Color in Excel & Google Sheets

This tutorial demonstrates how to copy the color of a cell in Excel and Google Sheets.

 

copy cell color 5

 

Copy Cell Color

Color With 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

 

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

 

copy cell color 2

 

As a result, the cell color is pasted.

 

copy cell color 3

 

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

Copy With Paste Special

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

 

copy cell color 8

 

  1. 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

 

  1. The Paste Special window appears. Under the Paste section, click on Formats. Then click on OK to finish.

 

copy cell color 10

 

As a result, the cell color is pasted.

 

copy cell color 11

 

Note: Using this method, it is not possible to copy only the color. All cell formatting is pasted (color of text, font, 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 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 the CTRL + C shortcut).

 

copy cell color 14

 

  1. 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, the cell color is pasted.

 

copy cell color 16