Copy Conditional Formatting in Google Sheets

You can simply use the online editor on browser, web-apps or native applications to collaborate with others simultaneously independent of the operating system without losing any features. One of the most well known basic feature is to simply copy rules applied to one set of cells to another set using Format Painter. 

The following steps show you how to make some advanced conditional formatting in Google Sheets : 

1. Use the Format Painter 

By involving the Format Painter in Google Sheets, you can undoubtedly duplicate your design in a similar sheet or an alternate one in your exercise manual. Remember that this technique duplicates the entirety of the arrangement, in addition to the conditional rule. Steps to follow: 

1. Select the cell(s) you need to copy the formatting from and click the Format Painter button in the toolbar. 

2. Select the cells where you need to paste the formatting. Assuming this is on an alternate sheet, just pick that sheet's tab at the base and then select the cells. 

Also, it's just as simple as that! You can affirm that your rule applies to the new cell range by going to Format > Conditional Formatting on that sheet to see the rule in the sidebar.

2. Copy and Paste Special 

One more method for replicating conditional formatting in Google Sheets is by utilizing Paste Special. With this technique, you can likewise paste the formatting in a similar sheet or an alternate one in the workbook. 

Steps to Follow: 

1. Select the cell(s) you need to copy the formatting from and afterward do one of the following: 

a. Right-click and choose "Copy." 

b. Pick Edit > Copy in the menu. 

2. Select the cells where you need to paste the formatting and afterward do one of the following: 

a. Right-click and choose "Paste Special." 

b. Pick Edit > Paste Special in the menu. 

At the point when the Paste Special choices show up, select "Conditional Formatting Only.” 

While using the Format Painter, you confirm that the rule applies to the new cells by opening the Conditional Formatting sidebar with Format > Conditional Formatting. 

3. Duplicate the Formatting Rule 

Perhaps you need to apply the same conditional formatting in your sheet however you need to make a separate rule. This is a choice to set up the same conditions, however adjust the formatting or vice versa. For this situation, you can duplicate the rule. 

Steps to follow: 

1. Select Format > Conditional Formatting from the menu to open the sidebar and pick the rule you need to copy to open it. 

2. At the bottom, pick "Add Another Rule" and click "Done."

This duplicates the rule and returns you to the conditional formatting screen in the sidebar. You should then see your original rule and its duplicate. 

3. Select the duplicate to open it, make your changes to the cell range, conditions, or formatting, and click "Done." 

You then have both rules for your sheet.

4. Expand the Range in the Rule 

For some reason if you don’t want to use the copy and paste options above, you can likewise alter the conditional formatting rule to include a new cell range. This is another option if you want the formatting in the same sheet but for cells not adjacent to those already in the rule. In the sheet where you need to copy the formatting, pick Format > Conditional Formatting from the menu to open the sidebar. Select the rule you wish to copy to open it. Steps to follow: 

1. Click the Select Data Range icon to the right of the Apply to Range box.

2. Pick “Add Another Range.” 

Either enter the additional cell range in the box or drag your cursor through it on your sheet.

3. Click "OK" to save the change and then click "Done" in the sidebar. You'll see the new cell range for your rule. 

Conclusion: The spreadsheet will have the ability to format itself as you are working on it in real time. This means that anything you do within the spreadsheet will be brought to your attention quicker if the cells were to change their format. Whether you wish to copy and paste the same rule or copy the rule and make slight changes, you have choices in Google Sheets 

Conditional Formatting used for making graph projections, tracking and collecting data, making budget analysis or to Make Art with Google Sheets. It's GOT IT ALL!!!