Microsoft KB Archive/185319

= XL98: Error Using Add-In Function in Conditional Formatting =

Article ID: 185319

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



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.

