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
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.
Next, select the range of values you want to apply the conditional formatting to.
Right-click on the selection and select Paste special > Conditional formatting only.
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.
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.
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.
While the Paint Format tool is activated, drag your cursor to select the range you want to apply the conditional formatting to.
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.
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.
More ways to do conditional formatting Google Sheets:
- Remove Conditional Formatting
- How To Do Conditional Formatting
- Conditional Formatting Based On Another Cell
- Conditional Formatting for Duplicates
- Conditional Formatting with a Checkbox
- Conditional Formatting with Multiple Conditions
- Conditional Formatting Based On Another Sheet
- Apply Conditional Formatting Across An Entire Row
- Conditional Formatting to Compare Two Columns
- Conditional Data Validation
- Color Scale Based On Another Cell
- Relative Reference
- Conditional Formulas
- Conditional Formatting Based On Another Cell Not Empty
- Conditional Formatting Based On Another Cell Date
- If Cell Contains Text in
- Highlight Cells
- Highlight Duplicate Cells
- Make Negative Numbers Red