How to Copy cells that contain conditional formatting in Excel

When you are using Excel, you may found that when you press Delete to delete a cell, you do not delete the conditional formatting for this cell. How can we delete conditional formatting in Excel?

It's very popular to use conditional formatting in many books and articles. By using conditional formatting in Excel, you can apply formatting automatically to one or more cells based on the value of the cell or the value of a formula.

When you have applied some conditional formatting rules in your worksheets, such as data bars, color scales, or icon sets to a range of cells, you can also edit the conditional formatting rules according to your own preference. If you have not yet used conditional formatting to the cells, please see the article titled How to Add Conditional Formatting to Cell in Excel (http://www.fanhow.com/knowhow:Add_Conditional_Formatting_to_Cell_in_Excel_34191519), which show you how to create conditional formatting rules in your worksheets. To edit conditional formatting rules in Excel 2007, follow the steps below: