I'd like to have a medium black top border across each row whose A column cell contains text in a Google Spreadsheet.
I'd also like to have the same top border across each row whose whole row is blank.
I understand Conditional Formatting doesn't include border formatting as it does in Excel, and I am as of yet unfamiliar with scripting in this web app.
Would someone be able to explain the process to generate this please?
Best Answer
The process that would generate a script that makes mentioned conditional formatting includes of course what you mentioned you are unfamiliar with: scripting.
A) Learn the basics of google apps script bound to google sheets. This is just a small part of apps script and this is good starting point. Most of the basics can be learned while trying to build your formatting script but you have to want to learn scripting.
B) In the sheets document, open the script editor and define the following function:
C) Install a trigger on your spreadsheet that triggers our 'onEdit' function when the sheet is edited. See the official HOWTO. Test that this simple trigger and code works. Also make sure you understand what the code expresses.
D) Write the code corresponding to the logic:
Note that the former is not apps script but pseudocode explaining the logic. This translates into the following apps script:
Small variation: iso 1 row the code underneath simply formats a single cell: