Functions return values. They can not modify other cells nor can they change
formatting when called from a sheet as a user defined function. If they are
called from code then they can do what they want but as a UDF they are
limited. Oddly enugh there are acouple of exceptions. They can change
comments in other cells and a couple of other weird ones (if I recall) but
not what you are looking to do.
--
HTH...

Jim Thomlinson


"Roger Starnes" wrote:

I've written an Excel function. I'd like for it to be able to change the
formatting of the cell that it's currently in depending on the what happens
in the function. I'd like the function to be able to control the font,
interior, and pattern. I don't want to use the conditional formating feature.