Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Applying UDF In Conditional Formatting
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Applying UDF In Conditional Formatting
On Thu, 28 May 2009 05:31:01 -0700, FARAZ QURESHI
wrote: 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. Put the UDF in some "other" cell. Then execute your Conditional Formatting based on the contents of that "other" cell. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Applying Conditional Formatting to a Max number in range | Excel Worksheet Functions | |||
Applying conditional formatting to dynamic range | Excel Discussion (Misc queries) | |||
applying conditional formatting to emtpy cells in a spreadsheet | Excel Discussion (Misc queries) | |||
Applying multiple distinct conditional formatting rules | Excel Discussion (Misc queries) | |||
Applying Conditional Formatting to Muliple Worksheets in Excel 200 | Excel Discussion (Misc queries) |