A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Changing fonts with a formula



 
 
Thread Tools Display Modes
  #1  
Old April 22nd, 2010, 09:38 AM posted to microsoft.public.excel.newusers
Blue Max
external usenet poster
 
Posts: 301
Default Changing fonts with a formula

Is there any way to change the font of a cell using conditional formats or a
formula that will specify the font?

It appears that conditional formats cannot be used to change the cell font
in Excel 2007. Is this correct? If not, is there a function similar to the
TEXT() function that would allow a user to insert text in a cell in a
specific font and size?

  #2  
Old April 22nd, 2010, 10:20 AM posted to microsoft.public.excel.newusers
ozgrid.com
external usenet poster
 
Posts: 328
Default Changing fonts with a formula

In a word, no.



--
Regards
Dave Hawley
www.ozgrid.com
"Blue Max" wrote in message
...
Is there any way to change the font of a cell using conditional formats or
a formula that will specify the font?

It appears that conditional formats cannot be used to change the cell font
in Excel 2007. Is this correct? If not, is there a function similar to
the TEXT() function that would allow a user to insert text in a cell in a
specific font and size?


  #3  
Old April 22nd, 2010, 10:59 AM posted to microsoft.public.excel.newusers
MS-Exl-Learner
external usenet poster
 
Posts: 135
Default Changing fonts with a formula

You can change the below using Conditional Formatting In Excel 2007.

Cell font Color/Font Style/Underline/Effects (Strike Through)/Cell
Format/Border Line Style / Border Line Color/Cell Background Color/Pattern
Color and Pattern Style.

But the font cannot be changed by using the CF.

--
Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Blue Max" wrote:

Is there any way to change the font of a cell using conditional formats or a
formula that will specify the font?

It appears that conditional formats cannot be used to change the cell font
in Excel 2007. Is this correct? If not, is there a function similar to the
TEXT() function that would allow a user to insert text in a cell in a
specific font and size?

.

  #4  
Old April 22nd, 2010, 12:31 PM posted to microsoft.public.excel.newusers
Ron Rosenfeld
external usenet poster
 
Posts: 3,719
Default Changing fonts with a formula

On Thu, 22 Apr 2010 02:38:23 -0600, "Blue Max" wrote:

Is there any way to change the font of a cell using conditional formats or a
formula that will specify the font?

It appears that conditional formats cannot be used to change the cell font
in Excel 2007. Is this correct? If not, is there a function similar to the
TEXT() function that would allow a user to insert text in a cell in a
specific font and size?


You can not change fonts with a formula. Functions can only return a value.

Conditional formatting will not change the font family, although it can change
certain attributes of the font (e.g. bold, italic, etc).

You can change the font family using a VBA macro; testing within the macro for
certain conditions so it works similar to conditional formatting. Is that what
you want? If so, provide more information.
--ron
  #5  
Old April 29th, 2010, 04:28 PM posted to microsoft.public.excel.newusers
Blue Max
external usenet poster
 
Posts: 301
Default Changing fonts with a formula

Thank you, Ron, and also to the others who responded. Unfortunately, it is
clear that conditional formats cannot be used to change the font. Sure hope
Microsoft will add this feature in the future. We also note that your
border line-thickness selections are far fewer than on the standard dialog -
a pity. We will look into using VBA, but had hoped for a simpler solution!

Thanks Everyone,

Richard


"Ron Rosenfeld" wrote in message
...
On Thu, 22 Apr 2010 02:38:23 -0600, "Blue Max"
wrote:

Is there any way to change the font of a cell using conditional formats or
a
formula that will specify the font?

It appears that conditional formats cannot be used to change the cell font
in Excel 2007. Is this correct? If not, is there a function similar to
the
TEXT() function that would allow a user to insert text in a cell in a
specific font and size?


You can not change fonts with a formula. Functions can only return a
value.

Conditional formatting will not change the font family, although it can
change
certain attributes of the font (e.g. bold, italic, etc).

You can change the font family using a VBA macro; testing within the macro
for
certain conditions so it works similar to conditional formatting. Is that
what
you want? If so, provide more information.
--ron


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:01 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.