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