Can you change cell fonts using formula?

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?
 
D

Don Guillett

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

Dave Peterson

Nope.

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

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

Dave Peterson

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is it possible to assign fonts using formular? 5
Formulas in Conditional Formula 5
Need Help with VLOOKUP 4
Excel Vlookup Help 0
Nesting mulptiple round functions 1
IF,AND... 1
vlookup copy down 1
Selecting an unmatched value 1

Top