conditional formatting - highlight Capital letters but not lower c
 

Is there a way to set conditional formatting to just highlight the Capital
letters and not the lower case Ie A not a?

Thanks

conditional formatting - highlight Capital letters but not lower c
 

If you mean where there is more in the cell than just the capital letter,
no.

If the cell would just contain say A, then use

=AND(A1<"",EXACT(A1,UPPER(A1)))

--

HTH

Bob

"elaine1" wrote in message
...
Is there a way to set conditional formatting to just highlight the Capital
letters and not the lower case Ie A not a?

Thanks