| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you change colors/fonts on a check box | Excel Discussion (Misc queries) | |||
| How do I change fonts in a DV drop down menu | Excel Worksheet Functions | |||
| can't change default fonts | Excel Discussion (Misc queries) | |||
| cann't change default fonts in excel | Excel Discussion (Misc queries) | |||
| How to change fonts in drop down list | Excel Discussion (Misc queries) | |||
Linear Mode
