Microsoft KB Archive/185318

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

Article ID: 185318

Article Last Modified on 10/22/2000

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q185318





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.

