Use UDF In Conditional Formatting

[Faraz Ahmed Qureshi]

Any guidance as to how to have a UDF in an addin be declared/registered etc.
so as to be used like all other usual/normal functions? like be autocompleted
upon partial entry, arguments be displayed in the supertip and be capable to
be used in the Conditional Formatting and other features?

 

[Jacob Skaria]

Hi Faraz

Check out the below by Jan Karel Pieterse

http://www.jkp-ads.com/articles/RegisterUDF01.asp

 

[Peter T]

In 97-2003, in the CF dialog change Cell Value Is to Formula Is and enter a
formula that evaluates to True/False.
In 2007+, in CF rules, click on "Use a Formula to determine which cells to
Format"

Enter your UDF in the normal way in the CF formula

Experiment with Relative & Absolute references, there are significant
differences in the way they work particularly when it comes to copying cells
with CFs.

Regards,
Peter T