Conditional formatting rules are duplicated when you copy and then paste cells in Excel 2007

Article translations Article translations
Article ID: 973823 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

In Microsoft Office Excel 2007, you apply conditional formatting to cells. When you copy and then paste the cells, the conditional formatting rules are duplicated even though the rules already exist in the cells.

RESOLUTION

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756 How to back up and restore the registry in Windows
To resolve this problem, follow these steps:
  1. Apply the following hotfix:
    973932 Description of the Excel 2007 hotfix package (Excel-x-none.msp, Xlconv-x-none.msp): August 25, 2009
  2. Set the
    ReplaceCFOnPaste
    registry entry. To do this, follow these steps:
    1. Click Start, click Run, type regedit, and then click OK.
    2. Locate and then click the following registry subkey:
      HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options
    3. On the Edit menu, point to New, and then click DWORD Value.
    4. Type ReplaceCFOnPaste, and then press ENTER.
    5. Right-click ReplaceCFOnPaste, and then click Modify.
    6. In the Value data box, type 1, and then click OK.
    7. Exit Registry Editor.

Properties

Article ID: 973823 - Last Review: September 23, 2009 - Revision: 1.0
APPLIES TO
  • Microsoft Office Excel 2007
Keywords: 
kbqfe kbexpertisebeginner kbsurveynew kbprb KB973823

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com