XL97: Error Using Add-In Function in Conditional Formatting

ID: Q185318

The information in this article applies to:

Microsoft Excel 97 for Windows

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.

Additional query words: XL97 atp

Keywords          : kbdta xlformat xladdins 
Version           : WINDOWS:97
Platform          : WINDOWS
Issue type        : kbprb

Last Reviewed: November 2, 1998