Hi Jason,

A user defined function (UDF) returns a value; it cannot change formatting
or alter its environment


---
Regards,
Norman



"Jason R Morris" <JasonRMorris@discussions.microsoft.com> wrote in message
news:8A8AFC30-C48E-43A9-B6CD-B46540955F7A@microsoft.com...
>I am trying to us an if then statment in a function to change the fill
>color
> of a cell if the conditions are true. I have tried
> "ActiveCell.Interior.ColorIndex = 6" that works in subs, but it does not
> works in functions.