Can you change cell fonts using formula?
 

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?

Can you change cell fonts using formula?
 

No. but you can change to text and do whatever is desired. However, you no
longer have a formula.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ayo" wrote in message
...
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?

Can you change cell fonts using formula?
 

Nope.

Formulas (and real numbers) can't have that character by character formatting.

Maybe you could use two columns/cells????

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?

--

Dave Peterson

Can you change cell fonts using formula?
 

And check your other post.

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?

--

Dave Peterson