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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
text formating formulas
Select the range you want to affect... Go to Format|Conditional Formatting Select Formula Is from 1st drop down Enter formula: =EXACT(G3,UPPER(G3)) Where G3 is the top most cell in your selection... Click Format and choose font styles from the Font Tab -- NBVC Where there is a will there are many ways. ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109359 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
text formating formulas
To the OP... Note that this method is not actually bringing over the formats
from the source data. It is conditionally formatting the results of the formula. That being said there is no way to bring over the formats. Formulas return values and not formats. There is no functinoallity in XL that allows you to dynamically take the formatting of one cell and place that onto another. -- HTH... Jim Thomlinson "NBVC" wrote: Select the range you want to affect... Go to Format|Conditional Formatting Select Formula Is from 1st drop down Enter formula: =EXACT(G3,UPPER(G3)) Where G3 is the top most cell in your selection... Click Format and choose font styles from the Font Tab -- NBVC Where there is a will there are many ways. ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109359 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
text formating formulas
"NBVC" wrote: Select the range you want to affect... Go to Format|Conditional Formatting Select Formula Is from 1st drop down Enter formula: =EXACT(G3,UPPER(G3)) Where G3 is the top most cell in your selection... Click Format and choose font styles from the Font Tab -- NBVC Where there is a will there are many ways. ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109359 Thanks, It worked great. |
Reply |
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 |