Font by way of function?

[Copacetic]

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?

 

[Mike Middleton]

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

 

[ozgrid.com]

VBA is your best bet. Simply record a macro.

 

[Steve Dunn]

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.