aka_krakur
Active Member
- Joined
- Jan 31, 2006
- Messages
- 438
I have a column in a spreadsheet (Column F) for this example. And I want to conditionally format only a portion of the text inside this column based on if cell contains text "1069 - xxxxx" then to format only that text 1069 - up until the next semi colon (if possible...if not at least just the 1069 -.
I've tried using the conditional format feature; but that doesn't have a if cell "contains" ability.
Then I tried using the Find/Replace. But for some reason that formats the entire contents of the cell if it finds 1069 (example below shows how using find/replace changes all the font to red, when I am only wanting the 1069 - red.)
I've tried using the conditional format feature; but that doesn't have a if cell "contains" ability.
Then I tried using the Find/Replace. But for some reason that formats the entire contents of the cell if it finds 1069 (example below shows how using find/replace changes all the font to red, when I am only wanting the 1069 - red.)
MDR Reportability Query.xls | ||||||
---|---|---|---|---|---|---|
F | G | H | I | |||
1 | ACTUAL_DEV_CODE_DESC | ENTRY_DATE | ACTUAL_DEVICE_CODE_LOC | ACTUAL_DEV_CLARIF | ||
2 | X100-NoMalfunctionIdentified;X100-NoMalfunctionIdentified;1069-BreakageofDevice;X100-NoMalfunctionIdentified; | X100-N/A;X100-N/A;1069-N/A;X100-N/A; | X100-N/A;X100-N/A;1069-Handle;X100-N/A; | |||
3 | 2203-Other(usewhenanothercodecannotbeidentified);X100-NoMalfunctionIdentified;1059-Bend;1069-BreakageofDevice;1339-Kink;2203-Other(usewhenanothercodecannotbeidentified); | 2203-N/A;X100-N/A;1059-N/A;1069-N/A;1339-Lumen;2203-N/A; | 2203-N/A;X100-N/A;1059-ProximalEnd;1069-Handle;1339-Shaft;2203-N/A; | |||
092706 |