Conditional format lowercase

L

LoriM1

Hi Everyone,
I have 2 companies parts in a spreadsheet. One set is uppercase and
one is lowercase. Example:
10x06-398f 4.54
10X6-398F 6.56

I would like to highlight the lowercase parts to
1. Find all of company number 1's price.
2. Make these two entries into one line:
10X6-398F 6.56 4.54

Any help you can give me will be greatly appreciated!
Lori
 
B

Bob Phillips

Use conditional formatting with a formula of

=EXACT(LOWER(A14),A14)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top