| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Font by way of function?
Hi guys...
Is there a function that assigns the font for a given cell or range? Or am I required to code it in VB? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Font by way of function?
Copacetic -
Is there a function that assigns the font for a given cell or range? < No, I don't think so. Or am I required to code it in VB? < Yes, but a VBA User Defined Function used on a worksheet can only return a value to a worksheet cell or cells. So, assigning a font would have to be done with a subroutine. - Mike http://www.MikeMiddleton.com "Copacetic" wrote in message ... Hi guys... Is there a function that assigns the font for a given cell or range? Or am I required to code it in VB? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Font by way of function?
VBA is your best bet. Simply record a macro.
-- Regards Dave Hawley www.ozgrid.com "Copacetic" wrote in message ... Hi guys... Is there a function that assigns the font for a given cell or range? Or am I required to code it in VB? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Font by way of function?
Hi,
look up Conditional Formatting in the help files. This may be what you are after. Otherwise, give us more of an explanation for what you are trying to achieve. "Copacetic" wrote in message ... Hi guys... Is there a function that assigns the font for a given cell or range? Or am I required to code it in VB? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function to Change Font | Excel Worksheet Functions | |||
| Using Lookup Function based on Font Color | Excel Worksheet Functions | |||
| Font Color Function | Excel Worksheet Functions | |||
| User defined function detects font colour | Excel Worksheet Functions | |||
| changing font style in a complex worksheet function | Excel Worksheet Functions | |||
Hybrid Mode
