Microsoft KB Archive/211617

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

Article ID: 211617

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q211617





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 behavior 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.

