| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting "if part of cell contents contains string"
Hi!
Given the following table (actually a very long one): column A is: A 1 Evergreen/Italia Marittima/Hatsu Marine 2 Evergreen/Italia Marittima/Hatsu Marine 3 Gold-Star-Zim, Emirates, SCI, MacAndrews column B is: B 1 HAM, RTM, THP, TAR, Port Said, TPP, KHH, NBO, SHA, YTN, HKG, TPP... 2 HAM, THP, ZEE, Port Said, CMB, TPP, KHH, YTN, HKG, OSA, TOK... 3 NYJ, PMH, CHS, BCN, CMB, TUT, JNP, MUN, BCN, NYJ. How can I highlight cells that contain "Port Said"? I presume conditional formatting, and the conditions will be different for Column A and column B? I know how to use conditional formatting is a cell has to be bigger than, exact, contain exacttly a certain string etc, but in this case it's about containing a certain string, beside other strings.. Thanks in advance! tom |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to increase size of "name box" and "contents of cell " displa. | New Users to Excel | |||
| How do I reference a cell as PART of a vlookup "Table_Array" locat | Excel Worksheet Functions | |||
| get the VLOOKUP function to return the "contents" of a cell? | Excel Worksheet Functions | |||
| What is a function in VBA EXCEL witch finds a string like "not" in cell and then deletes a row with this cell? | Excel Worksheet Functions | |||
| if one cell has "X" textin contents, then pull cell "Y"... | Excel Worksheet Functions | |||
Threaded Mode
