XL2000: Error Using Add-In Function in Conditional Formatting (211617)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q211617

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.

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.

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.
Modification Type:MajorLast Reviewed:11/5/2003
Keywords:kbprb KB211617
©2003 Microsoft Corporation. All rights reserved.