You’ll be able to at all times arrange one other conditional formatting rule in Google Sheets for one set of cells precisely the identical as one other. However why do the additional work? Listed here are a couple of methods you possibly can copy your conditional formatting.
Use the Format Painter
Through the use of the Format Painter in Google Sheets, you possibly can simply copy your formatting in the identical sheet or a distinct one in your workbook. Needless to say this technique copies the entire formatting, not simply the conditional rule.
RELATED: The way to Spotlight Blanks or Errors in Google Sheets
Choose the cell(s) you wish to copy the formatting from and click on the Format Painter button within the toolbar.
Choose the cells the place you wish to paste the formatting. If that is on a distinct sheet, merely select that sheet’s tab on the backside after which choose the cells.
And that’s all there may be to it! You’ll be able to verify that your rule applies to the brand new cell vary by going to Format > Conditional Formatting on that sheet to view the rule within the sidebar.
Copy and Paste Particular
One other strategy to copy conditional formatting in Google Sheets is by utilizing Paste Particular. With this technique, you can even paste the formatting in the identical sheet or a distinct one within the workbook.
RELATED: The way to Use the Paste Particular Choices in Google Sheets
Choose the cell(s) you wish to copy the formatting from after which do one of many following:
- Proper-click and select “Copy.”
- Choose Edit > Copy within the menu.
Choose the cells the place you wish to paste the formatting after which do one of many following:
- Proper-click and select “Paste Particular.”
- Choose Edit > Paste Particular within the menu.
When the Paste Particular choices seem, choose “Conditional Formatting Solely.”
Like when utilizing the Format Painter, you verify that the rule applies to the brand new cells by opening the Conditional Formatting sidebar with Format > Conditional Formatting.
Duplicate the Formatting Rule
Possibly you wish to apply the identical conditional formatting in your sheet however wish to create a separate rule. That is an possibility if you wish to arrange the identical circumstances however alter the formatting or vice versa. On this case, you possibly can duplicate the rule.
RELATED: The way to Mechanically Spotlight Sure Textual content in Google Sheets
Choose Format > Conditional Formatting from the menu to open the sidebar and decide the rule you wish to copy to open it.
On the backside, select “Add One other Rule” and click on “Finished.”
This duplicates the rule and returns you to the primary conditional formatting display within the sidebar. It’s best to then see your unique rule and its duplicate.
Choose the duplicate to open it, make your modifications to the cell vary, circumstances, or formatting, and click on “Finished.”
You then have each guidelines to your sheet.
Increase the Vary within the Rule
If for some cause you don’t wish to use the copy and paste choices above, you can even edit the conditional formatting rule to incorporate a brand new cell vary. This can be a good possibility if you’d like the formatting in the identical sheet however for cells not adjoining to these already within the rule.
RELATED: The way to Apply a Coloration Scale Based mostly on Values in Google Sheets
Within the sheet the place you wish to copy the formatting, decide Format > Conditional Formatting from the menu to open the sidebar. Choose the rule you wish to copy to open it.
Click on the Choose Information Vary icon to the proper of the Apply to Vary field.
Choose “Add One other Vary.”
Both enter the extra cell vary within the field or drag your cursor by it in your sheet.
Click on “OK” to save lots of your change after which click on “Finished” within the sidebar. You’ll then see the brand new cell vary to your rule.
There’s no cause to create a very new conditional formatting rule if you’d like the identical one elsewhere in your sheet or workbook. Whether or not you wish to copy and paste the very same rule or copy the rule and make slight changes, you could have choices in Google Sheets.
