text formating formulas

J

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
 
N

NBVC

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
 
J

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.
 
J

Jerbil

NBVC said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top