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.

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.

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, 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 been applied, after that click ESC to discard the brush as shown below.

%d bloggers like this: