Use UDF In Conditional Formatting

  • Thread starter Thread starter Faraz Ahmed Qureshi
  • Start date Start date
F

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?
 
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
 
Back
Top