Use UDF In Conditional Formatting
 

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?

--
Thanx in advance & Best Regards,

Faraz!

Use UDF In Conditional Formatting
 

Hi Faraz

Check out the below by Jan Karel Pieterse

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

--
Jacob (MVP - Excel)


"Faraz Ahmed Qureshi" wrote:

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?

--
Thanx in advance & Best Regards,

Faraz!

Use UDF In Conditional Formatting
 

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

"Faraz Ahmed Qureshi" wrote in
message ...
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?

--
Thanx in advance & Best Regards,

Faraz!