In this article:

Two Easy Ways to Copy Conditional Formatting in Google Sheets

Managing spreadsheets can be a mess, especially if you have a massive amount of data. Conditional formatting is the best option for you to quickly sort out cells based on their value in Google Sheets. This feature allows you to understand the sheet better and track your goals even at a glance.

Meanwhile, there are situations where you need to copy conditional formatting from a cell to another. An example of this is when you are creating a market sales on spreadsheet and you use conditional formatting for the month of June. However, July comes and you have to update the sheet again and use the same formatting in this column.

Now, applying conditional formatting on a specific range of cells is easy. With this, copying it to other cells or sheets should also be effortless. If you have no idea how to do it, this tutorial is for you.

Paint Format Tool

You might already be familiar with paint format or 'format painter.' It is a simple tool that you can use a specific format from a cell to another. This applies to conditional formatting too.

Spreadsheet named "Company A Monthly Sales" with paint format tool circled in red

Here are the steps that you should follow:

  1. Select the cell with conditional formatting that you want to copy.
  2. After that, click the painter format tool in the toolbar, which will then allow you to copy the format.
  3. Select the cells that you want to apply the formatting.

These steps are also applicable when copying the conditional format from a worksheet to another.



Copy + Paste Special

You will be surprised at how easy it is to use this trick. This is just copy-pasting the format of a specific range of cells to another.

Here is a more elaborate explanation to it:

  1. Select the range of cells that you want to copy the conditional formatting.
Google Spreadsheet with product, June, and July sales data. Column C has conditional formatting applied and is circled in red
  1. Right-click and choose copy option (you can also use keyboard shortcut Ctrl+C)
  2. Select the cells that you want to apply the conditional formatting to.
  3. Right-click on the selected cells.
  4. Hover over Paste Special and click 'Paste format only' from the option (to make it easier, use CONTROL + ALT + V).
Google Spreadsheet with product, June, and July sales data. Column E now has conditional formatting applied (copied from Column C) and is circled in red

Note that if you copy conditional formatting from a cell to another cell on the same sheet, it will not create a new rule for the cells where you pasted it. Meanwhile, copy-pasting a format of cells on a sheet to another will create a new rule for the second sheet.

Copy Conditional Formatting in a Google Sheets Spreadhseet

One of the easiest ways copy conditional formatting in google sheets is by using the copy formatting feature. Here are the steps:

  1. Select the cell with conditional formatting that you want to copy
  2. Right click on the the cell and click Ctrl + c on PC or ⌘ + c on Mac to Copy
  3. Select the cells you want to paste the copied conditional formatting to
  4. Right click on any of the selected cells and choose 'Paste Special' -> 'Paste Format Only'
  5. Alternatively, click on the selected cells and click Ctrl + Alt + v on windows and ⌘ + Option + v on mac to paste

Your conditional formatting will be pasted to your highlighted cells in google sheets.

Google Spreadsheet with product, June, and July sales data. Column E now has conditional formatting applied (copied from Column C) and is circled in red

Do you find this article helpful?

We are a software company that helps people access cross-platform data, create reliable reports, and gain helpful insights. If you’re looking to become a spreadsheet power user with skills in analyzing and presenting data, consider trying Lido and checking out other spreadsheet resources

Schedule a free automation consult
Learn more

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started