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


"Peo Sjoblom" wrote:

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

"cs_vision" wrote in message
...
This is how the cell looks"
BUFFENS, Delle - or
BUFFENS, Delle R. -

I wanted to highlight the entire cell
"Peo Sjoblom" wrote:

You can't if you mean highlight parts of a string in the same cell, if
strings in cells are all upper or something else you can use

=EXACT(UPPER(A1),A1)



--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"cs_vision" wrote in message
...
How do I conditional format only text that is upper case?