Conditional format lowercase
 

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


--
LoriM1
------------------------------------------------------------------------
LoriM1's Profile: http://www.excelforum.com/member.php...fo&userid=2815
View this thread: http://www.excelforum.com/showthread...hreadid=532043

Conditional format lowercase
 

Use conditional formatting with a formula of

=EXACT(LOWER(A14),A14)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"LoriM1" wrote in
message ...

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


--
LoriM1
------------------------------------------------------------------------
LoriM1's Profile:
http://www.excelforum.com/member.php...fo&userid=2815
View this thread: http://www.excelforum.com/showthread...hreadid=532043

Conditional format lowercase
 

Thank you!!!!
Lori


--
LoriM1
------------------------------------------------------------------------
LoriM1's Profile: http://www.excelforum.com/member.php...fo&userid=2815
View this thread: http://www.excelforum.com/showthread...hreadid=532043