Conditional Formatting based on Upper case

P

Peo Sjoblom

You need to give us more examples assuming that those 2 should be
highlighted what about an example that is not highlighted?
Is it always the first word that is upper as opposed to something like
Delle, BUFFENS ?


Peo
 
C

cs_vision

Here an example. I only wanted the name highlighted, the hypen is okay to

LEUSER, Rudolf -
will
dec. trust
trust rest.
living will
p/atty. - prop.
p/atty. - h.c.
durable p/atty
designa. of h/c surrogate
Michigan durable p/atty
Michigan designa. of patient advocate
 
P

Peo Sjoblom

Not really a good solution but it might catch most of them

=EXACT(UPPER(LEFT(A1,FIND(",",A1)-1)),LEFT(A1,FIND(",",A1)-1))

assuming that the format of a name is always the same with all caps last
name, comma and first name
of course if the comma is unique to the each occurrence of an all caps name
then you could use

=ISNUMBER(FIND(",",A1))


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com
 
Top