Note: you can use Ed's formula in FormatConditional FormattingFormula is to
color any UPPER cases.


Gord Dibben MS Excel MVP

On Mon, 04 Feb 2008 17:00:53 -0500, Ron Rosenfeld
wrote:

On Mon, 4 Feb 2008 13:47:01 -0800, Ed Cones
wrote:

Is there a function that'll tell me whether a single character in a cell is
upper or lower case? IsUpper() would be nice, but it ain't there ;)

Currently I'm just doing a case-sensitive sort to isolate them, but I'm
hoping for something quicker.

thx


=EXACT(A1,UPPER(A1))

will return true if the letter in A1 is uppercase; otherwise it will return
FALSE.
--ron