Excel: Copy conditional formatting to another cell

If you want to copy conditional formatting to another cell in Excel, you do not have to enter it again and again. We'll show you how it's done.

Excel: Copy conditional formatting to another cell

1. Click the cell that contains the conditional formatting that you want to copy.
2. Under the "Start" tab you will find a button with a brush at the top left. If you select the brush, your mouse pointer changes into it.
3. Now click on the top cell you want to format. Then drag the mouse pointer over all other cells that are also to be formatted.
4. To finish formatting, press the "Esc" key on your keyboard.

This practical tip shows you how to display several windows side by side in Excel.