XL97: Error Using Add-In Function in Conditional Formatting

• 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

Additional query words: XL97 atp

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