| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional format numbers | Excel Worksheet Functions | |||
| Cell Format Changes When Data Is Entered - Not Conditional Formatt | Excel Worksheet Functions | |||
| Conditional format of minimum number | Excel Worksheet Functions | |||
| Conditional Format Question | Excel Worksheet Functions | |||
| Draging a conditional format | Excel Worksheet Functions | |||
Hybrid Mode
