Question

Excel: Copy conditional formatting

Answer 1

This is how you can copy conditional formatting in Excel
1st step:
2nd step:
3rd step:
4th step:
quick start Guide

---

The formatting can be quickly transferred in new versions of Excel. We'll show you how to copy conditional formatting..

In the past, copying a conditional formatting was a laborious task - sometimes without success. You can use conditional formatting to format cells based on conditions or rules. To do this step-by-step for other cells is tedious. But Excel has now integrated a function to apply conditional formatting to additional lines. We'll show you how this works in the following.

This is how you can copy conditional formatting in Excel

In order to copy conditional formatting for other lines, care must be taken when pasting that not only the values ​​are copied by default. Follow our step-by-step instructions or take a look at the brief instructions .

1st step:

Open the Excel document with the conditional formatting. As an example, we have formatted the numbers from 1 to 10, scaled in color, conditionally. Select the cells by holding down the left mouse button.

2nd step:

Now right click and select " Copy ". Alternatively, you can press [Ctrl] + [C] to copy the content.

3rd step:

Then click on the first cell of the target area where the conditional formatting should be inserted. Now right-click again to select the first option under " Insert ". Otherwise only the values ​​will be copied. With older versions of Excel, you may need to select the " Insert formatting " option .

4th step:

Excel automatically inserts the conditional formatting for you. Of course, this also works with other formatting than the color scale. You have now successfully transferred the format to a new range of cells.

quick start Guide

1. Open the document and mark the cells that are to be transferred to a new cell range including the format.
2. A right-click to open the menu and select " Copy " from.
3. Now click on the first cell for the target range.
4. Using one right click , now select the first option under " Paste from."
5. You have now successfully transferred the format to a new range of cells .

---