Excel user defined functioned

  • Thread starter Thread starter mukulbhatt
  • Start date Start date
M

mukulbhatt

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Set non-continuous PrintArea via Function / Name 0
User Defined Function Help 3
Conditional formatting 2
Need help with macro for conditional formatting using number forma 1
#NAME? Error With User Defined Functions 7
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Formula to identify character formatting (bold, italic, etc) 3

Back
Top