XL98: Error Using Add-In Function in Conditional Formatting

• Microsoft Excel 98 Macintosh Edition

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

Additional query words: XL98 atp

Keywords : kbdta xlformat xladdins
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbprb