How To Copy Conditional Formatting In Google Sheets

Last Updated on November 2, 2023 by Jake Sheridan

In this tutorial, you will learn how to copy conditional formatting in Google Sheets.

How To Copy Conditional Formatting In Google Sheets

Conditional formatting is a great way to format your data based on certain conditions. For example, you may want to highlight all of the cells in a column that contain a certain value.

Once you have created a conditional formatting rule, you may want to copy it to other cells or columns in your sheet. This can be helpful if you want to apply the same formatting to a large number of cells.

In this guide, we will show you how to copy conditional formatting in Google Sheets.

How To Replicate Conditional Formatting In Google Sheets

Here’s how to replicate conditional formatting in Google Sheets

Step 1

First, select any cell that contains the conditional formatting you want to copy. Type the keyboard shortcut Ctrl + C to copy the selected cell.

In this example, we’ll copy the formatting in cell A2.

Step 2

Next, select the range of values you want to apply the conditional formatting to.

Step 3

Right-click on the selection and select Paste special > Conditional formatting only.

Step 4

The target range should now have the conditional formatting of the original cell you’ve selected.

Do note that this method will only copy the conditional formatting. Other formatting options such as cell borders or text alignment will remain as is. If you wish to also copy the original range’s formatting, you may instead select Paste special > Format only.

Step 5

Next, we’ll show you another way to copy conditional formatting using the Paint Format tool.

First, select any cell that includes the desired conditional formatting.

Step 6

Next, click on the Paint Format icon found on the left side of the toolbar.

Do note that the Paint Format feature works as a toggle. You may click it again to deactivate it if needed.

Step 7

While the Paint Format tool is activated, drag your cursor to select the range you want to apply the conditional formatting to.

Step 8

Once you release your cursor, the target range should now have the desired conditional formatting.

Do note that once you activate the Paint Format tool, you can only copy the formatting once. You will need to activate it once more to copy formatting again.

Summary

This guide should be everything you need to copy conditional formatting in Google Sheets

You may make a copy of this example spreadsheet to test it out on your own.