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