View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
R Avery R Avery is offline
external usenet poster
 
Posts: 220
Default 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!