In Excel, it's very general that cells contain conditional formatting, and when we copy these cells, how can we copy cells that contain conditional formatting in Excel?
- Right click on the cell that you want to copy, choose Copy.
- Then click Paste to copy the cells. And this also contain the conditional formatting, if you want to copy only the formatting (including conditional formatting), choose the Paste Special.
- Then check Formats box and click OK to complete the copy.
- Now you know 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:
Related Unresolved Questions