From: Copacetic on
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?
From: Mike Middleton on
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" <Copacetic(a)iseverythingalright.org> wrote in message
news:95iis5dctkr8q3o2kg9bhsr0dj23ftn7hj(a)4ax.com...
> 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?

From: ozgrid.com on
VBA is your best bet. Simply record a macro.



--
Regards
Dave Hawley
www.ozgrid.com
"Copacetic" <Copacetic(a)iseverythingalright.org> wrote in message
news:95iis5dctkr8q3o2kg9bhsr0dj23ftn7hj(a)4ax.com...
> 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?

From: Steve Dunn on
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" <Copacetic(a)iseverythingalright.org> wrote in message
news:95iis5dctkr8q3o2kg9bhsr0dj23ftn7hj(a)4ax.com...
> 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?