You are currently viewing How to copy conditional formatting in Excel

How to copy conditional formatting in Excel

Microsoft Excel is a powerful Microsoft application that business owners are utilizing today. This application combines simplicity with efficiency to increase business productivity. With so many tasks that you can perform using this application, there's room for you to learn new skills each day.

Excel has some features that can help you highlight important data to make the spreadsheet data more visible, easy to interpret and accessible to clients and partners. Today, we are going to guide you along with conditional formatting in excel.

This feature allows you to create formatting rules depending on the content cells. A good example is a rule that says that a cell with over 100o values to display in Orange and that over 100 to display in red. After setting this rule, the cells will display with a red background.

The main reason why many people choose this feature of conditional formatting is to make sure clients and partners can easily spot these cells. Let`s get to Business and show you how to copy conditional formatting in Excel.

1. Copy and paste conditional formatting to another cell

Conditional formatting will give you a chance to format the cells to another cell or even a range of cells. The good thing is that you can copy the conditional formatting rule that has applied to one cell to another cell or even a range of cells. Here are the different approaches that you can use for this purpose.

2. Simple copy and paste

This is the easiest way to copy the conditional formatting to another cell. You can do this with simple copy-paste to the target cell or even a range of cells if you want the rule to apply to many cells. The first step is to highlight the cell that you want to copy and eventually hit the copy button. This button can easily be found in the Home Tab or even by clicking Control +C. After this, head to the target cell and press Control +V or right-click to paste what you have copied. One major drawback of this approach is that it will not only copy the rule but also the values. It can be a daunting task to correct the values and change to the values that are supposed to be on the target cell. For those people that don't want to deal with this problem, then this approach is not the best for you.

3. Using the format Pointer

The other approach that can help you copy conditional formatting in excel is Format Painter. This approach is the best because it will only copy the conditional formatting rule only and not the rule plus the values. What this means is that using this rule, it will not impact your dataset.

This feature is available directly on the clipboard section in the Home tab. The feature will only copy the formatting applied on one cell to the other cell.

To apply the feature, you are simply supposed to click on the cell to copy the formatting rule. After that, click on the Format Painter icon and you will see the pointer changes to the paintbrush. After that, drag the brush to the range of cells or the cell where you want the rule copied. After you are done using the brush, you can press Esc to stop using it.

After you choose to select the rule form copying and applying it to another cell, let`s say D3:f7, you will have to click on the Format Painter and change the pointer to brush. After that drag, it across the range from D3 to F7. Leave the mouse there and you will see that the rule has already applied, after that click ESC to discard the brush as shown below.

I bet you have already realized how simple it is to use the Format Painter approach as compared to the simple copy-paste approach. However, the approach you take here will depend entirely on your needs and what you want to achieve. Again it will also depend on the amount of data and the time you have formatting. Though, I usually recommend the use of a Format painter because it`s easy and it will not copy the rule and the values.