XL97: Error Using Add-In Function in Conditional Formatting (185318)


The information in this article applies to:

  • Microsoft Excel 97 for Windows
This article was previously published under Q185318

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 problem 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.

STATUS

This behavior is by design of Microsoft Excel.

REFERENCES

For more information about using conditional formatting, click Contents And Index on the Help menu, click the Index tab in Microsoft Excel Help, type the following text

conditional formats

and then double-click the selected text to go to the "Highlight data that meets conditions you specify" topic. If you are unable to find the information you need, ask the Office Assistant.
Modification Type:MajorLast Reviewed:10/22/2000
Keywords:kbprb KB185318
©2002 Microsoft Corporation. All rights reserved.