text formating formulas

[Jerbil]

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

 

[Jim Thomlinson]

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.

 

[Jerbil]

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/showthread.php?t=109359

Thanks, It worked great.