Thread: Is it possible to assign fonts using formular?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default Is it possible to assign fonts using formular?
A formula can only return a result to the cell. It cannot modify
anything else, including formatting. If you manually format part of a
cell's content, that formatting will be deleted when the formula is
recalculated.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]



On Tue, 2 Feb 2010 13:52:01 -0800, Ayo
wrote:

I have a formular:
=REPT("|",(VLOOKUP($E$4,SummaryTable,6,FALSE)/200))& " " &
VLOOKUP($E$4,SummaryTable,6,FALSE)

but I need to change the font of the 2nd
"VLOOKUP($E$4,SummaryTable,6,FALSE)" section.
Is this possible to do?
Reply With QuoteReply With Quote