| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bold Text Formatting
I am using this formula to combine a city location (first lookup below) and
the address the (second lu below) in a Wrapped text cell. My question is, is there a way to Bold the first lookup? I want the City to be bold, but the addres length varies and will not fit into the available column width--unless it is possible to change the font size of each lookup. Say the city in 14 pt and the address in 10 pt. =VLOOKUP(B5,rkstores,2)&CHAR(10)&CHAR(10)&" "&VLOOKUP((B5+1800),marshdata,7) Thanks Reno |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting based on text within a formula | Excel Worksheet Functions | |||
| conditional formatting with text | Excel Discussion (Misc queries) | |||
| How do I get selected text within a cell to remain bold in excel? | Excel Discussion (Misc queries) | |||
| Banding with Conditional Formatting with Multiple Conditions | Excel Worksheet Functions | |||
| Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) | |||
Threaded Mode
