| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel user defined functioned
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel user defined functioned
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel user defined functioned
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| user-defined charts in Excel 2007 | Charts and Charting in Excel | |||
| Excel Solver as User Defined Funcntion | Excel Worksheet Functions | |||
| "User-defined type not defined" message in Excel | Excel Discussion (Misc queries) | |||
| How can I create a user defined function in excel? | Excel Discussion (Misc queries) | |||
| Excel user defined functions. | Excel Worksheet Functions | |||
Linear Mode
