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