Can you change cell fonts using formula?

  • Thread starter Thread starter Ayo
  • Start date Start date
A

Ayo

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?
 
No. but you can change to text and do whatever is desired. However, you no
longer have a formula.
 
Nope.

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

Maybe you could use two columns/cells????
 
And check your other post.
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?
Click to expand...
 
Back
Top