Applying UDF In Conditional Formatting

F

FARAZ QURESHI

How can I have a UDF, which is saved in an addin installed, be applied in the
conditional formatting? Because upon applying a conditional formatting like
=NOT(ISFORMULA(A1))
so as to highlight the cell(s) without a formula results into a popup of:

You cannot use reference to other worksheets or workbooks for Conditional
Formatting criteria.
 
R

Ron Rosenfeld

How can I have a UDF, which is saved in an addin installed, be applied in the
conditional formatting? Because upon applying a conditional formatting like
=NOT(ISFORMULA(A1))
so as to highlight the cell(s) without a formula results into a popup of:

You cannot use reference to other worksheets or workbooks for Conditional
Formatting criteria.
Click to expand...

Put the UDF in some "other" cell. Then execute your Conditional Formatting
based on the contents of that "other" cell.
--ron
 
Top