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

Other People Are Reading

Instructions

  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

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

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