How to copy and paste for conditional formatting in Excel

Written by paul travers Google
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to copy and paste for conditional formatting in Excel
Microsoft's Excel is a popular spreadsheet application. (Microsoft Corporation)

Conditional formatting allows you to apply formats to Excel cells that meet predefined conditions. You could, for example, stipulate that all cells with a value of 100 or more appear in bold or a different colour to the rest of the cells. This makes it ideal for highlighting important information within a spreadsheet. Applying conditional formatting to each cell individually can be a time-consuming process, but you can quickly copy and paste formatting from one cell to another.

Skill level:
Moderately Easy


  1. 1

    Open an Excel spreadsheet and select the cell with the conditional formatting you wish to copy. Right-click the cell and select "Copy" or hold "Ctrl" and press "C" on the keyboard to copy data to the clipboard.

  2. 2

    Right-click the cell you wish to copy the conditional formatting to. To copy to more than one cell, select by clicking and dragging. Left-click the first cell, then drag to highlight further cells while holding the mouse button. Right click anywhere in the highlighted area.

  3. 3

    Select "Paste Special" from the menu that appears. Select "Formats" then click "OK." The formatting will now be copied to all the selected cells.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.