HeliRecords
New Member
- Joined
- Feb 7, 2018
- Messages
- 6
| I need help with borders on this spreadsheet. This is a combination of several spreadsheets which I didn't build. This has 6 set columns. Each numbered task may contain 1 to 6 rows. I need to place a border around EACH task. There is data in column A for each task. Is it possible to create a conditional formula that would look at Column A and determine if there was data. If there is data then place a upper border along the entire row. Ex - Since there is Data in A1, I need an upper border along A1-F1 Since there is no Data in A2, No border A3 - border A4 - no border A5 - no border A6 - border A7 border [TABLE="class: outer_border, width: 500"] <tbody>[TR] [TD] | A | B | C | D | E | F |
| 1 | 26-1 | INSPECT PORTABLE FIRE EXTINGUISHER FOR CONDITION AND WEIGHT. | NFPA-10 | Mod 2 Sup Insp | 1187.3 | |
| 2 | ||||||
| 3 | 28-1 | PERFORM FUNCTIONAL TEST OF FUEL LOW SENSOR. | 28-40-00, 5-2 | Mod 2 | 959.5 | |
| 4 | ||||||
| 5 | ||||||
| 6 | 29-1 | CHANGE FLUID OF HYDRAULIC SYSTEM NO. 1 AND NO. 2. REPLACE FILTERS, REINSTALL ALL REMOVED COWLINGS. | 29-00-00, 3-3 | Mod 2 | 1187.3 | |
| 7 | 29-2 | REMOVE HYDRAULIC PUMP, INSPECT DRIVE SPLINES, LUBRICATE SPLINES USING SUNSTRAND SPLINE LUBE AND REINSTALL WITHOUT DISCONNECTING HYDRAULIC LINES. | 29-10-00, 4-1 STEP 1,2,3,6,7 29-10-00, 4-2 | Mod 2 | 1187.3 | |
| 8 | ||||||
| 9 | ||||||
| 10 | ||||||
| 11 |
<tbody>
</tbody>
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 879"]
<tbody>[TR]
[TD="class: xl65, width: 105"]Mod 2[/TD]
[/TR]
</tbody>[/TABLE]
