Spreadsheet: 154144d1336245048-conditional-formatting-highlight-cells-in-a-column-that-contain-1-or-more-words-example
Sheet: Sheet2

 | Relative [NAME] (ft.) | P/S ON (V) | P/S OFF (V) | Remarks | Actual [NAME] (ft.) | DATE | TIME | LATITUDE | LONGITUDE | ELEVATION |  |  | HVY BRUSH
20415 |  | -1.786 | -1.33 | D70 | 50996 | 03/29/2012 | 09:05:56 | 41.60682297 | -87.34288788 | 604.5 |  |  | BAD
45104 |  | -1.252 |  | (ACV: 0.2311V), T PWR LINE | 112732 | 03/31/2012 | 15:22:02 | 41.61048889 | -87.12944031 | 639 |  |  | UNCUT
47986 |  | -1.585 | -1.266 | (ACV: 0.3123V), T PWR LINE | 119955 | 03/31/2012 | 16:38:15 | 41.61678696 | -87.10646057 | 638 |  |  | OFFSET
5045 |  |  | -1.074 | (ACV: 0.5549V), HVAC, LINE PARALLELS | 12796 | 03/27/2012 | 14:11:04 | 41.63672256 | -87.46782684 | 601
5603 |  |  | -0.93 | (ACV: 0.5765V), HVAC, LINE PARALLELS | 14157 | 03/27/2012 | 14:28:23 | 41.63320923 | -87.4666748 | 589.2
6718 | 16790 | -1.255 | -0.835 | (ACV: 0.5863V), BAD TEST STATION, [NAME], STATION NUMBER 167+90, MP 3.18, PL MKR, CASING VENT, HVAC LINE PARALLELS | 16956 | 03/28/2012 | 10:43:18 | 41.63043594 | -87.46018219 | 592.3
56689 |  | -1.509 | -1.239 | UNCUT ROW, MAY NOT BE ON LINE | 141474 | 04/01/2012 | 10:40:18 | 41.62525177 | -87.03859711 | 676
10020 |  |  | -1.157 | (ACV: 0.7147V), END, HVAC LINE PARALLELS, T PWR LINE | 25001 | 03/29/2012 | 07:58:40 | 41.62997055 | -87.43099976 | 595.1
3776 |  |  | -1.113 | (ACV: 1.0125V), HVAC, START PARALLELS | 9681 | 03/27/2012 | 10:12:59 | 41.64396667 | -87.46337891 | 589.2
32938 |  |  | -1.145 | (ACV: 1.7265V), T PWR LINE | 83045 | 03/31/2012 | 12:47:23 | 41.59361649 | -87.2325592 | 615.7
32955 |  | -1.664 |  | (ACV: 1.9072V), T PWR LINE | 83088 | 03/31/2012 | 12:47:57 | 41.59359741 | -87.23239136 | 614.2
34905 |  |  | -1.394 | (ACV: 2.312V), START, HVAC LINE PARALLELS | 87919 | 03/31/2012 | 08:31:44 | 41.59593964 | -87.21625519 | 599.2
35265 |  | -1.675 |  | (ACV: 3.272V), END, HVAC PARALLELS | 88799 | 03/31/2012 | 08:37:40 | 41.59681702 | -87.21323395 | 595.8
15254 |  | -1.144 | -0.996 | (Line/casing: Struct P/S -1.144V IRF -0.995V, Casing P/S -0.781V IRF -0.734V) (ACV: 0.5053V), [NAME], ROW, STATION NUMBER UNKNOWN, CASING VENT | 37603 | 03/28/2012 | 15:19:40 | 41.62163162 | -87.38724518 | 595
26411 |  | -1.389 | -1.135 | (Line/casing: Struct P/S -1.346V IRF -1.097V, Casing P/S -0.259V IRF -0.231V) (ACV: 0.3204V), [NAME], ROW, STATION NUMBER UNKNOWN, CASING VENT | 66482 | 03/29/2012 | 16:05:33 | 0 | 0 | 0
14833 |  | -1.376 | -1.195 | (Line/casing: Struct P/S -1.416V IRF -1.195V, Casing P/S -0.992V IRF -0.909V), [NAME], ROW, STATION NUMBER UNKNOWN, EJ & E R/R, CASING VENT | 36508 | 03/28/2012 | 15:11:05 | 41.62318039 | -87.39070892 | 594.9
2557 |  | -1.275 |  | COKE PILE, OFFSET | 6644 | 03/28/2012 | 10:21:04 | 41.64569473 | -87.47032166 | 593.3
22955 |  | -1.89 | -1.578 | (Line/casing: Struct P/S -1.914V IRF -1.584V, Casing P/S -0.258V IRF -0.219V) (ACV: 0.7068V), [NAME], CASING VENT AT TENNESSEE RD, STATION NUMBER UNKNOWN, PL MKR, POWER LINE XING | 57608 | 03/29/2012 | 13:51:28 | 41.60232544 | -87.32229614 | 605.6
22044 |  | -2.477 | -1.373 | (Line/casing: Struct P/S -2.431V IRF -1.386V, Casing P/S -0.510V IRF -0.403V) (ACV: 0.3986V), [NAME], ROW, STATION NUMBER UNKNOWN, CASING VENT | 55230 | 03/29/2012 | 12:36:06 | 41.60396576 | -87.3296051 | 601.5
57090 |  | -1.491 | -1.217 | BEGINNING CULTIVATION, D46 | 142494 | 04/01/2012 | 10:52:38 | 41.62605286 | -87.03504944 | 680.7
14967 |  |  |  | CASING VENT | 36857 | 03/28/2012 | 15:13:23 | 41.62275696 | -87.38955688 | 595.9
15035 |  |  |  | CASING VENT | 37034 | 03/28/2012 | 15:14:57 | 41.62249756 | -87.38900757 | 596.4
17269 |  |  |  | CASING VENT, PL MKR | 42869 | 03/28/2012 | 16:45:57 | 41.61529922 | -87.36981201 | 592.3
8 |  | -2.612 | -1.255 | CEMENT WALL | 18 | 03/27/2012 | [NAME] | 41.66068649 | -87.47797394 | 633.7
13851 |  | -1.399 |  | CONTINUE, OFFSET ON FLD ROAD, HVY BRUSH, UNCUT ROW, CAN MOVE THROUGH IT 20FT LEFT OF LINE | 34276 | 03/29/2012 | 11:18:53 | 41.62607574 | -87.39859772 | 592.6
54243 |  | -1.538 | -1.274 | D 45 | 135298 | 04/02/2012 | 08:06:36 | 41.62592316 | -87.05697632 | 645.8
54328 |  | -1.462 | -1.19 | D 47 | 135521 | 04/02/2012 | 08:04:30 | 41.62591553 | -87.05615234 | 650.2
54281 |  | -1.57 | -1.291 | D 48 | 135398 | 04/02/2012 | 08:06:05 | 41.6259346 | -87.05660248 | 661.3
57975 |  | -1.522 | -1.245 | UNCUT ROW, IMPASSABLE ROW, HVY BRUSH, MAY NOT BE ON LINE | 144766 | 04/01/2012 | 11:27:35 | 41.62668991 | -87.0273056 | 648.5