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