Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
text formating formulas
I have a chemical inventory list where there are specific chemicals where
this formula =VLOOKUP(A2,Sheet2!$A$2:$C$224,2,FALSE) brings over the chemical name in all capital letters to sheet 1. If I format the capitalized chemical names in the VLOOKUP sheet2 with bold and italics the formatting is dropped when brought over to the formula cell. How can I bold and italic only the chemical names that are capitalized? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drag formulas, not formating | Excel Discussion (Misc queries) | |||
Conditional Formating/Formulas | Excel Discussion (Misc queries) | |||
formulas\conditional formating | Excel Worksheet Functions | |||
Formulas and/or formating | Excel Worksheet Functions | |||
Conditional formating using formulas | Excel Worksheet Functions |