Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL2000: Error Using Add-In Function in Conditional Formatting

XL2000: Error Using Add-In Function in Conditional Formatting

View products that this article applies to.

This article was previously published under Q211617

↑ Back to the top

Symptoms

When you click OK in the Conditional Formatting dialog box, you may receive the following error message:
You may not use references to other worksheets or workbooks for Conditional Formatting criteria.

↑ Back to the top

Cause

This behavior occurs when the following conditions are true:
  • You click Formula Is in the leftmost list in the Conditional Formatting dialog box.

    -and-
  • You attempt to use a function that is provided by an add-in.

    NOTE: This includes add-ins that are included with Microsoft Excel, such as the Analysis ToolPak add-in.

    -or-
  • You attempt to use a custom function that is in another workbook.

↑ Back to the top

References

For more information about using conditional formatting, click Microsoft Excel Help on the Help menu, type conditional formats in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

↑ Back to the top

Keywords: KB211617, kbprb

↑ Back to the top

Article Info
Article ID : 211617
Revision : 5
Created on : 11/5/2003
Published on : 11/5/2003
Exists online : False
Views : 304