XL98: Error Using Add-In Function in Conditional Formatting (185319)


The information in this article applies to:

  • Microsoft Excel 98 Macintosh Edition
This article was previously published under Q185319

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 98 Macintosh Edition.

REFERENCES

For more information about using conditional formatting, click Contents And Index on the Help menu (or on the Balloon Help menu if you are using a version of the Macintosh operating system earlier than 8.0), click the Index button in Microsoft Excel Help, type the following text

conditional formats

and then click Show Topics. Select the "Highlight data that meets conditions you specify" topic, and click Go To. If you are unable to find the information you need, ask the Office Assistant.
Modification Type:MajorLast Reviewed:9/11/2002
Keywords:kbprb KB185319
©2002 Microsoft Corporation. All rights reserved.