|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