Not sure if this is what you are after, but it may get you closer...

Rng.Font.ColorIndex = 3

See this site for a list of colors:
http://www.mvps.org/dmcritchie/excel/colors.htm


Regards,
Ryan--

--
RyGuy


"Billy Liddel" wrote:

You can't format the result of a UDF only in a macro. Could you not use
Conditional Formatting based on the result of the UDF?

Peter

" wrote:

I am trying to format a cell through user defined function. Code is
like.

ActiveCell.Font.Color = Red

but it is not working.
Is there any way to format a cell ( color, bold etc..)?

thanks