Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting using Custom VBA functions
I have a custom function that takes an excel range and returns a variant
array of doubles. I put this in a module in the workbook that i am using it. I can use it to do things like having a cell formula = "=funct(A1)=max(funct(A1:A10))", and it works correctly. However, when I try to use the same exact formula as above in conditional formatting, it does not work. THe conditional formatting just doesn't do anything. Is this a bug in Excel, or am I missing something? Any help would be most appreciated! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting using Custom VBA functions
Never mind! I figured it out. My function didn't properly take care of
blank cells in the range. Now it works properly. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting using Custom VBA functions
Actually, I do have a question. When calling custom vba functions from
within conditional formatting, and i set a breakpoint in the code for the function, it never breaks, even though i know that the conditional formatting is evaluating itself again. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom function with conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional Formatting - Applying Format Based Custom Functions | Excel Discussion (Misc queries) | |||
Conditional formatting/functions | Excel Discussion (Misc queries) | |||
OR Functions in a Conditional Formatting Furmula | Excel Worksheet Functions | |||
combining conditional formatting and functions | Excel Worksheet Functions |